Chapter 3: Pentaho Data Integration Getting Started -- Lookups and Formatting | Hitachi Vantara
Hamburger Hamburger Hamburger
en_us

Chapter 3: Pentaho Data Integration Getting Started -- Lookups and Formatting

After you filter records with missing postal codes, you are ready to resolve the missing ZIP Codes. You will use a second text file containing a list of cities, states and postal codes to look up the postal codes for those records that were missing.

{ "FirstName": "First Name", "LastName": "Last Name", "Email": "Business Email", "Title": "Job Title", "Company": "Company Name", "Address": "Address", "City": "City", "State":"State", "Country":"Country", "Phone": "Business Telephone", "LeadCommentsExtended": "Additional Information(optional)", "LblCustomField1": "What solution area are you wanting to discuss?", "ApplicationModern": "Application Modernization", "InfrastructureModern": "Infrastructure Modernization", "Other": "Other", "DataModern": "Data Modernization", "GlobalOption": "If you select 'Yes' below, you consent to receive commercial communications by email in relation to Hitachi Vantara's products and services.", "GlobalOptionYes": "Yes", "GlobalOptionNo": "No", "Submit": "Submit", "EmailError": "Must be valid email.", "RequiredFieldError": "This field is required." }
en