{"id":11127,"date":"2017-06-13T08:20:19","date_gmt":"2017-06-13T12:20:19","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=11127"},"modified":"2017-11-03T08:01:05","modified_gmt":"2017-11-03T12:01:05","slug":"how-to-build-realistic-but-fake-pii","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/","title":{"rendered":"How to Build Realistic but Fake PII"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">There are times when it is necessary to test with or share data that has elements of personally identifiable information (PII). To comply with data privacy laws and prevent a data breach, you may need to provide data that reflects, and sometimes imparts, critical information, but still protects the PII.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This article shows how you can build realistic, and privacy-law-compliant, test PII data using a variety of features in the <\/span><a href=\"http:\/\/www.iri.com\/products\/voracity\"><span style=\"font-weight: 400;\">IRI Voracity<\/span><\/a><span style=\"font-weight: 400;\"> data management platform and its core <\/span><a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl\"><span style=\"font-weight: 400;\">SortCL<\/span><\/a><span style=\"font-weight: 400;\"> program. SortCL is the 4GL for data definition and manipulation best known to <\/span><a href=\"http:\/\/www.iri.com\/products\/cosort\"><span style=\"font-weight: 400;\">IRI CoSort<\/span><\/a><span style=\"font-weight: 400;\"> users, <\/span><i><span style=\"font-weight: 400;\">and <\/span><\/i><span style=\"font-weight: 400;\">the parent program of <\/span><a href=\"http:\/\/www.iri.com\/products\/fieldshield\"><span style=\"font-weight: 400;\">IRI FieldShield<\/span><\/a><span style=\"font-weight: 400;\"> (for PII discovery and masking) and <\/span><a href=\"http:\/\/www.iri.com\/products\/rowgen\"><span style=\"font-weight: 400;\">IRI RowGen<\/span><\/a><span style=\"font-weight: 400;\"> (for test data generation).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Voracity includes FieldShield and RowGen, plus a DB subsetting wizard that can produce realistic, referentially correct test data. But this article shows a fourth path through Voracity that combines these technologies through the parent SortCL program.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We will demonstrate how you can use this functionality in Voracity to:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">disguise PII <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">impart other information that is not sensitive <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">maintain the original structure of the data. <\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">All these features are supported in the same, free Eclipse graphical IDE for Voracity &#8212; and all IRI products &#8212; called <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h3><b>Define the Objectives<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The chart below shows us the requirements for our test file. The original data from this file might come from health, insurance claim, and\/or personnel records.<span id='easy-footnote-1-11127' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#easy-footnote-bottom-1-11127' title='See our series on test data planning and management considerations &lt;a href=&quot;http:\/\/www.iri.com\/blog\/test-data\/tdm-primer\/&quot;&gt;here&lt;\/a&gt;.'><sup>1<\/sup><\/a><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11155 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/01-Chart.png\" alt=\"Chart\" width=\"635\" height=\"571\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/01-Chart.png 635w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/01-Chart-300x270.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><span style=\"font-weight: 400;\">Our test targets can be one or more of the following:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">flat-file<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">database table<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">formatted report<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">structured data stream (pipe, procedure, broker)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">To create the fake data, we need to start with real data. It will be used as a guide for creating the field values for our target. The final output will be sorted by an encrypted ID Number.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To automate the creation of our job, we will use a wizard in IRI Workbench to produce a SortCL script. Once created, the job script can be used on any server where SortCL is installed.<span id='easy-footnote-2-11127' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#easy-footnote-bottom-2-11127' title='CoSort or Voracity users license SortCL for back-end use on any Linux, Unix or Windows platform.'><sup>2<\/sup><\/a><\/span><\/span><span style=\"font-weight: 400;\">\u00a0 There are multiple ways to <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\/voracity-gui\/design\"><span style=\"font-weight: 400;\">create, modify, and run<\/span><\/a><span style=\"font-weight: 400;\"> these scripts in IRI Workbench. But this article focuses mostly on the script result, so you can see what happens \u201cunder the covers.\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Our job script will have an:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">INPUT section to define the fields as they exist in our original data source<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">INREC section to redefine some of the input fields and create new fields. All fields used for processing in the output must be defined here. \u00a0We are using this phase to remove unnecessary input fields and the consolidate common input fields from disparate metadata. If all the processing can be accomplished in the OUTPUT section, this section is not required. \u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ACTION section to sort or copy data from INPUT or INREC, and pass it to the output<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">OUTPUT section where final processing, values, and formats are defined for each target<\/span><b>\f<\/b><\/li>\n<\/ul>\n<h3><b>Define the Methods<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">This chart outlines how the original real data will be changed:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11132 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Real-Data-Chart.png\" alt=\"Real Data Chart\" width=\"555\" height=\"434\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Real-Data-Chart.png 555w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Real-Data-Chart-300x235.png 300w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Real-Data-Chart.png\"><br \/>\n<\/a><\/span><span style=\"font-weight: 400;\">Here is a sample of our input file called <\/span><i><span style=\"font-weight: 400;\">RealData <\/span><\/i><span style=\"font-weight: 400;\">which contains the original values:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11133 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/RealData.png\" alt=\"RealData\" width=\"561\" height=\"451\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/RealData.png 561w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/RealData-300x241.png 300w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">We will use graphical wizards and dialogs in IRI Workbench to build our job script.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Be sure to first create a project where all the files will be saved. Click on it to make it the active project for all of our design work. I called my project <\/span><i><span style=\"font-weight: 400;\">FakeData<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Before we can start, we must ensure the fake values we need will look realistic. One method is to draw from the values in \u201cset\u201d files. Set files are composed of one or more columns with known acceptable values. The columns must contain ASCII readable characters and be separated by a tab.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here are the set files we need:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">male first names<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">female first names<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">last names<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">states and associated cities<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">values for incrementing DOB<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">IRI provides all of these except the last. That one we need to create. The incremental values need to be in days; therefore, if we want to increase DOB by one year, the increment is 366 days. To vary the month and day, we can use both negative and positive ranges of values; e.g., -742 thru -366 and 366 thru 749.<\/span><\/p>\n<h3><b>Create the DOB Increment Set<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">There are several kinds of set files that you can build in IRI Workbench, including a numeric range.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Follow these steps to build <\/span><i><span style=\"font-weight: 400;\">dob_increment.set<\/span><\/i><span style=\"font-weight: 400;\">:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on the <\/span><b>RowGen<\/b><span style=\"font-weight: 400;\"> (windmill) icon on the IRI Workbench toolbar. Select <\/span><b>New Set File<\/b><span style=\"font-weight: 400;\"> from the menu.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>New Set File Wizard Selection <\/b><span style=\"font-weight: 400;\">dialog, select <\/span><b>Range or Literal Values<\/b><span style=\"font-weight: 400;\"> and click <\/span><b>Next<\/b><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In <\/span><b>Setup Options<\/b><span style=\"font-weight: 400;\">, type <\/span><i><span style=\"font-weight: 400;\">dob_increment<\/span><\/i><span style=\"font-weight: 400;\"> for <\/span><b>File name. <\/b><span style=\"font-weight: 400;\">\u00a0<\/span><i><span style=\"font-weight: 400;\">.set<\/span><\/i><span style=\"font-weight: 400;\"> will be added to the end of the name. \u00a0Click <\/span><b>Next<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Create Range or Literal Values <\/b><span style=\"font-weight: 400;\">dialog, select <\/span><b>NUMERIC <\/b><span style=\"font-weight: 400;\">from the <\/span><b>Data Type <\/b><span style=\"font-weight: 400;\">dropdown. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select <\/span><b>Range from <\/b><span style=\"font-weight: 400;\">under<\/span><b> Create set file entries<\/b><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the field to the right, type the value -742 and then -366 in the next field. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Under the field with the -742 value, select <\/span><b>Including this value<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Add to table<\/b><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Do the same for first the 366 value and then the 749 value. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select <\/span><b>Including this value<\/b><span style=\"font-weight: 400;\"> under the 749. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">View these values in the <\/span><b>Preview<\/b><span style=\"font-weight: 400;\"> box and then click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Range-File.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11134\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Range-File.png\" alt=\"Range File\" width=\"472\" height=\"497\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Range-File.png 472w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Range-File-285x300.png 285w\" sizes=\"(max-width: 472px) 100vw, 472px\" \/><\/a><\/p>\n<h3><b>Create the Job Script<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Even though we will be using multiple de-identification techniques, we can build our entire job with the <\/span><b>New Sort Job <\/b><span style=\"font-weight: 400;\">wizard (since the target will be ordered by IDNUM). Launch the wizard from the CoSort menu (stopwatch icon) on the IRI Workbench toolbar:<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Sort-Job.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11135\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Sort-Job.png\" alt=\"New Sort Job\" width=\"525\" height=\"463\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Sort-Job.png 525w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Sort-Job-300x265.png 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">I am calling my job script<\/span><i><span style=\"font-weight: 400;\"> fakedata.scl<\/span><\/i><span style=\"font-weight: 400;\">. Be sure <\/span><b>Create script<\/b><span style=\"font-weight: 400;\"> is selected, then click <\/span><b>Next<\/b><span style=\"font-weight: 400;\"> to go to the <\/span><b>Data Source <\/b><span style=\"font-weight: 400;\">dialog.<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the<\/span><b> File name<\/b><span style=\"font-weight: 400;\"> field, type in fakedata, then click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">. The .scl will be added for you.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>N<\/b><b>ext<\/b><span style=\"font-weight: 400;\"> to go to the <\/span><b>Data Sources<\/b><span style=\"font-weight: 400;\"> dialog.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click<\/span><b> Add Data Source. <\/b><span style=\"font-weight: 400;\">In the <\/span><b>Data Source<\/b><span style=\"font-weight: 400;\"> dialog, make sure <\/span><b>Files <\/b><span style=\"font-weight: 400;\">is selected; then type RealData \u00a0in the field. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>OK <\/b><span style=\"font-weight: 400;\">to go to back to the<\/span><b> Data Sources <\/b><span style=\"font-weight: 400;\">dialog<\/span><b>.<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Now define the metadata by selecting<\/span><b> Add Existing Metadata <\/b><span style=\"font-weight: 400;\">or <\/span><b>Discover Metadata<\/b><span style=\"font-weight: 400;\">. See an example of how data sources and their metadata (.ddf details) get defined in <\/span><a href=\"http:\/\/www.iri.com\/blog\/migration\/data-migration\/using-the-nextform-file-format-conversion-wizard\/\"><span style=\"font-weight: 400;\">this article<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The names and data TYPES for the input fields are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IDNUM, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">FNAME, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">LNAME, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">GENDER, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">STATE, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">CITY, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">CODE1, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">CODE2, TYPE=ASCII<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">DOB, TYPE=ISO_DATE<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">After defining that <\/span><b>Data Source<\/b><span style=\"font-weight: 400;\">, select <\/span><b>Pre-Action Layout<\/b><span style=\"font-weight: 400;\"> in the <\/span><b>Data Sources<\/b><span style=\"font-weight: 400;\"> window.<\/span><\/p>\n<h4><b>Define the Pre-Action \/ INREC Section<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">The Pre-Action, or INREC, phase is where you change the value of fields, or create new fields, before they move into the ACTION and OUTPUT phases. For this job, we want to sort on the encrypted IDNUM field.<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Pre-Action<\/b><span style=\"font-weight: 400;\"> window, select <\/span><b>Add<\/b> <b>Pre-Action<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select <\/span><b>Edit Pre-Action Layout<\/b><span style=\"font-weight: 400;\"> to open the <\/span><b>Pre-Action Field Layout<\/b><span style=\"font-weight: 400;\"> mapping window. Initially, all the fields from the source<\/span><i><span style=\"font-weight: 400;\"> RealData <\/span><\/i><span style=\"font-weight: 400;\">are copied to the <\/span><b>Pre-Action <\/b><span style=\"font-weight: 400;\">(<\/span><b>Inrec<\/b><span style=\"font-weight: 400;\">) section.<\/span><\/li>\n<\/ol>\n<h4><b>Define the New INREC Fields<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">All the fields below are created in the <\/span><b>Pre-Action Field Layout<\/b><span style=\"font-weight: 400;\"> mapping window. Each field will be derived using a different technique so <\/span><i><span style=\"font-weight: 400;\">fake <\/span><\/i><span style=\"font-weight: 400;\">data can replace <\/span><i><span style=\"font-weight: 400;\">real <\/span><\/i><span style=\"font-weight: 400;\">data according to our objectives above.<\/span><\/p>\n<p><b>ENC_FP_IDNUM<br \/>\n<\/b><i><span style=\"font-weight: 400;\">Encrypt the IDNUM field<\/span><\/i><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right-click on the field <\/span><i><span style=\"font-weight: 400;\">IDNUM <\/span><\/i><span style=\"font-weight: 400;\">-&gt; <\/span><b>Apply Rule<\/b><span style=\"font-weight: 400;\"> -&gt; <\/span><b>Create Rule<\/b><span style=\"font-weight: 400;\">. \u00a0This takes you to the window <\/span><b>New Field Rule Wizard Selection<\/b><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Encryption or Decryption Functions<\/b><span style=\"font-weight: 400;\">. Be sure the library location has our project name. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The field <\/span><b>Rule name<\/b><span style=\"font-weight: 400;\"> will have the name <\/span><i><span style=\"font-weight: 400;\">EncryptionRule<\/span><\/i><span style=\"font-weight: 400;\">. Change this name to something more descriptive (<\/span><i><span style=\"font-weight: 400;\">EncryptionRuleIDNUM<\/span><\/i><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">)<br \/>\n<\/span><\/span><\/span><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Field-Rule-Wizard.png\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11136\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Field-Rule-Wizard.png\" alt=\"New Field Rule Wizard\" width=\"469\" height=\"673\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Field-Rule-Wizard.png 469w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/New-Field-Rule-Wizard-209x300.png 209w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/> <\/a><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Next<\/b><span style=\"font-weight: 400;\"> to go to the <\/span><b>Encryption and Decryption Functions<\/b><span style=\"font-weight: 400;\"> window.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select <\/span><i><span style=\"font-weight: 400;\">enc_fp_aes256_alphanum<\/span><\/i><span style=\"font-weight: 400;\">. Any encryption function that has an <\/span><i><span style=\"font-weight: 400;\">fp<\/span><\/i><span style=\"font-weight: 400;\"> in the name is a <\/span><a href=\"http:\/\/www.iri.com\/solutions\/data-masking\/encryption\/format-preserving-encryption\"><span style=\"font-weight: 400;\">format preserving encryption<\/span><\/a><span style=\"font-weight: 400;\"> function. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Type in a <\/span><b>Passphrase.<\/b><span style=\"font-weight: 400;\"> This is used for the encryption key. I used 123, but you can use any value and a variety of encryption key management techniques.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Encryption-Decryption-Functions.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11137\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Encryption-Decryption-Functions.png\" alt=\"Encryption &amp; Decryption Functions\" width=\"600\" height=\"445\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Encryption-Decryption-Functions.png 702w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Encryption-Decryption-Functions-300x223.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">It is possible to re-use <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\/fieldshield-gui\/apply-rules\"><span style=\"font-weight: 400;\">saved rules<\/span><\/a><span style=\"font-weight: 400;\"> in this or other projects.<\/span><\/p>\n<p><b>NEW_FNAME<br \/>\n<\/b><i><span style=\"font-weight: 400;\">Conditional Selection of a Set File<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">This field is created in the INREC phase to replace the original first name value with a value in one of two IRI-provided set files with gender-specific first names. \u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right-click on the field <\/span><i><span style=\"font-weight: 400;\">FNAME<\/span><\/i><b>. <\/b><span style=\"font-weight: 400;\">This opens the <\/span><b>Pre-Action Field<\/b><span style=\"font-weight: 400;\"> window. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Change <\/span><b>Field Name<\/b><span style=\"font-weight: 400;\"> to <\/span><i><span style=\"font-weight: 400;\">NEW_FNAME<\/span><\/i><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the <\/span><b>Value<\/b><span style=\"font-weight: 400;\"> tab. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For the field <\/span><b>Transformation Type<\/b><span style=\"font-weight: 400;\">, select <\/span><b>If Then Else<\/b><span style=\"font-weight: 400;\"> from the dropdown. This is selected because our job will be conditionally selecting the set file from which the values are drawn. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Next to the <\/span><b>Value <\/b><span style=\"font-weight: 400;\">field, click <\/span><b><i>f \u2026 <\/i><\/b><span style=\"font-weight: 400;\">\u00a0so we can define the condition logic in the <\/span><b>Expression Builder<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Categories <\/b><span style=\"font-weight: 400;\">box of the <\/span><i><span style=\"font-weight: 400;\">Expression Builder<\/span><\/i><span style=\"font-weight: 400;\">, select <\/span><b>Field Names<\/b><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Double-click on the field <\/span><i><span style=\"font-weight: 400;\">GENDER <\/span><\/i><span style=\"font-weight: 400;\">in the <\/span><b>Items<\/b><span style=\"font-weight: 400;\"> box. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In <\/span><b>Categories<\/b><span style=\"font-weight: 400;\">, click <\/span><b>Relational Operators<\/b><span style=\"font-weight: 400;\">, \u00a0double-click <\/span><b>EQ<\/b><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click the quotes (<\/span><b>\u201c\u201d<\/b><span style=\"font-weight: 400;\">) located below the <\/span><b>Else<\/b><span style=\"font-weight: 400;\"> field, then type an <\/span><i><span style=\"font-weight: 400;\">M <\/span><\/i><span style=\"font-weight: 400;\">between them.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Place the cursor in the <\/span><b>Then<\/b><span style=\"font-weight: 400;\"> field and type <\/span><i><span style=\"font-weight: 400;\">SET=&#8221;names_male_first.set<\/span><\/i><span style=\"font-weight: 400;\">&#8220;.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Place the cursor in the <\/span><b>Else<\/b><span style=\"font-weight: 400;\"> field and type <\/span><i><span style=\"font-weight: 400;\">SET=&#8221;names_female_first.set<\/span><\/i><span style=\"font-weight: 400;\">&#8220;<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Notice the green check which indicates a valid expression has been created.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Expression-Builder.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11138\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Expression-Builder.png\" alt=\"Expression Builder\" width=\"424\" height=\"565\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Expression-Builder.png 424w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Expression-Builder-225x300.png 225w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">The IF-THEN-ELSE logic will appear in the <\/span><b>Value<\/b><span style=\"font-weight: 400;\"> field of the <\/span><b>Pre-Action Field<\/b><span style=\"font-weight: 400;\"> window. Click <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> to return to the <\/span><b>Pre-Action Field Layout<\/b><span style=\"font-weight: 400;\"> Window.<\/span><\/p>\n<p><b>NEW_LNAME<br \/>\n<\/b><i><span style=\"font-weight: 400;\">Random Value Replacement from a Set File<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">This field is created in the INREC phase to replace the original last name value with values in an IRI-provided file called names_last.set.<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the mapping dialog, right-click on the field <\/span><i><span style=\"font-weight: 400;\">LNAME<\/span><\/i><span style=\"font-weight: 400;\">-&gt; <\/span><b>Edit. <\/b><span style=\"font-weight: 400;\">This opens the <\/span><b>Pre-Action Field<\/b><span style=\"font-weight: 400;\"> window. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Change the <\/span><b>Field Name <\/b><span style=\"font-weight: 400;\">to <\/span><i><span style=\"font-weight: 400;\">NEW_LNAME<\/span><\/i><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the <\/span><b>Value<\/b><span style=\"font-weight: 400;\"> tab. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For the field <\/span><b>Transformation Type<\/b><span style=\"font-weight: 400;\">, select <\/span><b>Set:File<\/b><span style=\"font-weight: 400;\"> from the dropdown.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For <\/span><b>File<\/b><span style=\"font-weight: 400;\">, you can type in the name for the set file (<\/span><i><span style=\"font-weight: 400;\">names_last.set<\/span><\/i><span style=\"font-weight: 400;\">) or click the <\/span><b>Define<\/b><span style=\"font-weight: 400;\"> button to browse to it. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11139\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field.png\" alt=\"Pre-Action Field\" width=\"541\" height=\"436\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field.png 541w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-300x242.png 300w\" sizes=\"(max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<p><b>NEW_CITY<br \/>\n<\/b><i><span style=\"font-weight: 400;\">Select a Value from a Valid-Pair Set File<\/span><\/i><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right-click on the field <\/span><i><span style=\"font-weight: 400;\">CITY &#8211;<\/span><\/i><span style=\"font-weight: 400;\">&gt; <\/span><b>Edit. <\/b><span style=\"font-weight: 400;\">This opens the <\/span><b>Pre-Action Field<\/b><span style=\"font-weight: 400;\"> window. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Change <\/span><b>Field Name<\/b><span style=\"font-weight: 400;\"> to <\/span><i><span style=\"font-weight: 400;\">NEW_CITY.<\/span><\/i><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the <\/span><b>Value<\/b><span style=\"font-weight: 400;\"> tab. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For the field <\/span><b>Transformation Type<\/b><span style=\"font-weight: 400;\">, select <\/span><b>Set: File<\/b><span style=\"font-weight: 400;\"> from the dropdown.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For <\/span><b>File<\/b><span style=\"font-weight: 400;\">, type the name for the set file (<\/span><i><span style=\"font-weight: 400;\">state_city.set<\/span><\/i><span style=\"font-weight: 400;\">) or click <\/span><b>Define<\/b><span style=\"font-weight: 400;\"> to browse to it. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on <\/span><b>Look-up Value<\/b><span style=\"font-weight: 400;\">. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Look-up Value<\/b><span style=\"font-weight: 400;\"> dialog, select the field <\/span><i><span style=\"font-weight: 400;\">STATE <\/span><\/i><span style=\"font-weight: 400;\">from the dropdown for <\/span><b>Look-up Value<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>ADD. <\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>OK, <\/b><span style=\"font-weight: 400;\">then<\/span><b> OK <\/b><span style=\"font-weight: 400;\">again.<\/span><\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Look-up-Value.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11141\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Look-up-Value.png\" alt=\"Look-up Value\" width=\"544\" height=\"522\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Look-up-Value.png 544w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Look-up-Value-300x288.png 300w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><\/a><\/p>\n<p><b>DOB_INCREMENT<br \/>\n<\/b><i><span style=\"font-weight: 400;\">Select a Value from a Numeric Range for Date Arithmetic<\/span><\/i><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right-click on field <\/span><i><span style=\"font-weight: 400;\">DOB <\/span><\/i><span style=\"font-weight: 400;\">&gt; <\/span><b>Insert below<\/b><span style=\"font-weight: 400;\"> -&gt; <\/span><b>Field. <\/b><span style=\"font-weight: 400;\">This opens the <\/span><b>Pre-Action Field<\/b><span style=\"font-weight: 400;\"> window. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For <\/span><b>Field Name<\/b><span style=\"font-weight: 400;\">, type in <\/span><i><span style=\"font-weight: 400;\">DOB_INCREMENT.<\/span><\/i><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select NUMERIC from the dropdown for <\/span><b>Data Type,<\/b><span style=\"font-weight: 400;\"> then make sure the <\/span><b>Precision<\/b><span style=\"font-weight: 400;\"> is zero (0).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the <\/span><b>Value<\/b><span style=\"font-weight: 400;\"> tab. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For the field <\/span><b>Transformation Type<\/b><span style=\"font-weight: 400;\">, select <\/span><b>Set: File<\/b><span style=\"font-weight: 400;\"> from the dropdown. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For <\/span><b>File<\/b><span style=\"font-weight: 400;\">, type the name for the set file (<\/span><i><span style=\"font-weight: 400;\">dob_increment.set<\/span><\/i><span style=\"font-weight: 400;\">) or click <\/span><b>Define<\/b><span style=\"font-weight: 400;\"> to browse to it.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">We have now defined all the fields we need in the INREC section of the job. Click on the <\/span><b>123 <\/b><span style=\"font-weight: 400;\">icon to renumber the positions for the fields, then click <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> and <\/span><b>Next<\/b><span style=\"font-weight: 400;\">. This takes you to the <\/span><b>Sort<\/b><span style=\"font-weight: 400;\"> dialog.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11142\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png\" alt=\"Pre-Action Field Layout\" width=\"600\" height=\"596\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png 670w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout-150x150.png 150w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout-300x298.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h4><b>Define the Sort<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">The box on the left lists our <\/span><b>Inrec <\/b><span style=\"font-weight: 400;\">fields. \u00a0The box on the right is where sort key fields are listed. To sort on the encrypted IDNUM field:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on ENC_FP_IDNUM<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select Add Key from the buttons in the middle. That field is then copied to the <\/span><b>Key Fields<\/b><span style=\"font-weight: 400;\"> box. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Next <\/b><span style=\"font-weight: 400;\">to go to the <\/span><b>Data Targets <\/b><span style=\"font-weight: 400;\">dialog.<\/span><\/li>\n<\/ol>\n<h4><b>Define the Target<\/b><\/h4>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Add Data Target<\/b><span style=\"font-weight: 400;\">. Type in <\/span><i><span style=\"font-weight: 400;\">FakeData<\/span><\/i><span style=\"font-weight: 400;\">.dat for <\/span><b>File<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> to return to the <\/span><b>Data Targets<\/b><span style=\"font-weight: 400;\"> window <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Target Field Layout<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">All the fields from <\/span><b>Inrec<\/b><span style=\"font-weight: 400;\"> are copied automatically into <\/span><i><span style=\"font-weight: 400;\">FakeData.dat<\/span><\/i><span style=\"font-weight: 400;\">, but we need to remove the computational field <\/span><i><span style=\"font-weight: 400;\">DOB_INCREMENT<\/span><\/i><span style=\"font-weight: 400;\"> because it should not display. Right-click on the field <\/span><i><span style=\"font-weight: 400;\">DOB_INCREMENT -&gt; Remove<\/span><\/i><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">We do however, need to create a new field, called \u00a0<\/span><i><span style=\"font-weight: 400;\">NEW_DOB<\/span><\/i><span style=\"font-weight: 400;\">, to reflect a DOB incremented by the <\/span><i><span style=\"font-weight: 400;\">dob_increment<\/span><\/i><span style=\"font-weight: 400;\"> value:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right click on the field <\/span><i><span style=\"font-weight: 400;\">DOB &#8211;<\/span><\/i><span style=\"font-weight: 400;\">&gt; <\/span><b>Edit<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Type <\/span><i><span style=\"font-weight: 400;\">NEW_DOB<\/span><\/i><span style=\"font-weight: 400;\"> for <\/span><b>Field Name<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select <\/span><b>ISO_DATE<\/b><span style=\"font-weight: 400;\"> from the <\/span><b>Data Type<\/b><span style=\"font-weight: 400;\"> menu<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the <\/span><b>Value<\/b><span style=\"font-weight: 400;\"> tab<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select <\/span><b>Expression<\/b><span style=\"font-weight: 400;\"> from the <\/span><b>Transformation Type<\/b><span style=\"font-weight: 400;\"> menu<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the <\/span><b><i>f &#8230; <\/i><\/b><span style=\"font-weight: 400;\">button to open the <\/span><b>Expression<\/b> <b>Builder<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the Expression Builder\u2019s <\/span><b>Categories <\/b><span style=\"font-weight: 400;\">box, select <\/span><b>Field Names<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Double-click on the field <\/span><i><span style=\"font-weight: 400;\">DOB<\/span><\/i><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on the plus sign (<\/span><i><span style=\"font-weight: 400;\">+<\/span><\/i><span style=\"font-weight: 400;\">)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Double-click on the field <\/span><i><span style=\"font-weight: 400;\">DOB_INCREMENT<\/span><\/i><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">, <\/span><b>OK, OK, <\/b><span style=\"font-weight: 400;\">and then<\/span><b> Finish<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Field-Assignment-Expression.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11143\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Field-Assignment-Expression.png\" alt=\"Field Assignment Expression\" width=\"440\" height=\"513\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Field-Assignment-Expression.png 440w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Field-Assignment-Expression-257x300.png 257w\" sizes=\"(max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">The script we built now appears in the IRI Workbench syntax-aware editing window. There are several ways to modify it:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right-click in the script editing window to bring up a menu of section-specific dialogs <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right-click on an element in the outline view to bring up the section- or element-specific dialog<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Edit the script directly if you know the scripting language<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Work from workflow and transform mapping <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/creating-voracity-flows-using-existing-iri-scripts-part-1\/\"><span style=\"font-weight: 400;\">diagrams<\/span><\/a><span style=\"font-weight: 400;\"> generated from this script, particularly if you are working in an ETL environment.<\/span><\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Script-in-IRI-Workbench.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11144\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Script-in-IRI-Workbench.png\" alt=\"Script in IRI Workbench\" width=\"600\" height=\"395\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Script-in-IRI-Workbench.png 1167w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Script-in-IRI-Workbench-300x197.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Script-in-IRI-Workbench-768x505.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Script-in-IRI-Workbench-1024x674.png 1024w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Here is my job script:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11145 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Job-Script.png\" alt=\"Script in IRI Workbench\" width=\"620\" height=\"626\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Job-Script.png 620w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Job-Script-150x150.png 150w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Job-Script-297x300.png 297w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">There are multiple <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/running-iri-jobs-in-the-iri-workbench\/\"><span style=\"font-weight: 400;\">ways to run<\/span><\/a><span style=\"font-weight: 400;\"> this script from IRI Workbench. You can also copy it to any Windows, Linux, or Unix server where the CoSort (SortCL) executable is licensed, and run it directly there.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Right-click in the body of the script -&gt; <\/span><b>Run as<\/b><span style=\"font-weight: 400;\"> -&gt; <\/span><b>IRI job<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here is the fake data my script produced:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11146 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Fake-Data.png\" alt=\"Fake Data\" width=\"601\" height=\"454\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Fake-Data.png 601w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Fake-Data-300x227.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Contact <\/span><a href=\"mailto:voracity@iri.com\"><span style=\"font-weight: 400;\">voracity@iri.com<\/span><\/a><span style=\"font-weight: 400;\"> for help using the IRI Workbench <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\/voracity-gui\"><span style=\"font-weight: 400;\">GUI for Voracity<\/span><\/a><span style=\"font-weight: 400;\"> for these things, and more:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Encoding a value with format-preserving encryption<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Using values in set files for:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">direct replacement<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">conditional set selection for replacement<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">lookup<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Performing arithmetic to change a value<\/span><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>There are times when it is necessary to test with or share data that has elements of personally identifiable information (PII). To comply with data privacy laws and prevent a data breach, you may need to provide data that reflects, and sometimes imparts, critical information, but still protects the PII. This article shows how you<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\" title=\"How to Build Realistic but Fake PII\">Read More<\/a><\/div>\n","protected":false},"author":10,"featured_media":11142,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,363,91,29],"tags":[280,1270,328,13,546,520,526,789,148,1269,1268,1119,68,88],"class_list":["post-11127","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-quality","category-iri-workbench","category-test-data","tag-data-discovery","tag-data-making","tag-data-management","tag-data-protection-2","tag-iri-cosort","tag-iri-fieldshield","tag-iri-rowgen","tag-iri-voracity","tag-personally-identifiable-information","tag-privacy-law-compliant","tag-realistic-but-fake-pii","tag-script","tag-sortcl","tag-test-data-2"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Build Realistic but Fake PII - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Build Realistic but Fake PII - IRI\" \/>\n<meta property=\"og:description\" content=\"There are times when it is necessary to test with or share data that has elements of personally identifiable information (PII). To comply with data privacy laws and prevent a data breach, you may need to provide data that reflects, and sometimes imparts, critical information, but still protects the PII. This article shows how youRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-13T12:20:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-03T12:01:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png\" \/>\n\t<meta property=\"og:image:width\" content=\"670\" \/>\n\t<meta property=\"og:image:height\" content=\"665\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Gegner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Gegner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"How to Build Realistic but Fake PII\",\"datePublished\":\"2017-06-13T12:20:19+00:00\",\"dateModified\":\"2017-11-03T12:01:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\"},\"wordCount\":2287,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png\",\"keywords\":[\"data discovery\",\"data making\",\"data management\",\"data protection\",\"IRI CoSort\",\"IRI FieldShield\",\"IRI RowGen\",\"IRI Voracity\",\"personally identifiable information\",\"privacy-law-compliant\",\"realistic but fake PII\",\"script\",\"SortCL\",\"test data\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Quality (DQ&#041;\",\"IRI Workbench\",\"Test Data\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\",\"name\":\"How to Build Realistic but Fake PII - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png\",\"datePublished\":\"2017-06-13T12:20:19+00:00\",\"dateModified\":\"2017-11-03T12:01:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png\",\"width\":670,\"height\":665,\"caption\":\"Pre-Action Field Layout\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Build Realistic but Fake PII\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\",\"name\":\"Susan Gegner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"caption\":\"Susan Gegner\"},\"url\":\"https:\/\/beta.iri.com\/blog\/author\/susang\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Build Realistic but Fake PII - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/","og_locale":"en_US","og_type":"article","og_title":"How to Build Realistic but Fake PII - IRI","og_description":"There are times when it is necessary to test with or share data that has elements of personally identifiable information (PII). To comply with data privacy laws and prevent a data breach, you may need to provide data that reflects, and sometimes imparts, critical information, but still protects the PII. This article shows how youRead More","og_url":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/","og_site_name":"IRI","article_published_time":"2017-06-13T12:20:19+00:00","article_modified_time":"2017-11-03T12:01:05+00:00","og_image":[{"width":670,"height":665,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png","type":"image\/png"}],"author":"Susan Gegner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Gegner","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"How to Build Realistic but Fake PII","datePublished":"2017-06-13T12:20:19+00:00","dateModified":"2017-11-03T12:01:05+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/"},"wordCount":2287,"commentCount":1,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png","keywords":["data discovery","data making","data management","data protection","IRI CoSort","IRI FieldShield","IRI RowGen","IRI Voracity","personally identifiable information","privacy-law-compliant","realistic but fake PII","script","SortCL","test data"],"articleSection":["Data Masking\/Protection","Data Quality (DQ&#041;","IRI Workbench","Test Data"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/","url":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/","name":"How to Build Realistic but Fake PII - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png","datePublished":"2017-06-13T12:20:19+00:00","dateModified":"2017-11-03T12:01:05+00:00","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png","width":670,"height":665,"caption":"Pre-Action Field Layout"},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/how-to-build-realistic-but-fake-pii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Build Realistic but Fake PII"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63","name":"Susan Gegner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","caption":"Susan Gegner"},"url":"https:\/\/beta.iri.com\/blog\/author\/susang\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2017\/06\/Pre-Action-Field-Layout.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/11127"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=11127"}],"version-history":[{"count":19,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/11127\/revisions"}],"predecessor-version":[{"id":11131,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/11127\/revisions\/11131"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/11142"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=11127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=11127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=11127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}