Chapter 2: Pentaho Data Integration Getting Started -- Filter Records
In this exercise, you will filter out those records' missing postal codes where the POSTALCODE is not null (the true condition), and ensure only complete records are loaded into the database table.
Storage Software, Data Integration & Analytics
{
"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
Hello, Let me know how I can help you today.
Chat with our sales experts or call us at 1-678-403-3035 .