Tag: key value format in pentaho

Extract column and value separated by Delimiter

admin

Today, I will discuss about the scenario where data is present in a format column:value . See the below sample data for the same. EmpId :1 Emp_First_Name:Ram Emp_Last_Name:Kumar Address:GachiBowli ,Hyderabad Phone_Number:1234567890 Pin_code:122011 Such kind of data you might get in colleges,schools where admin team ask each student to fill in these details and in backend , it is getting stored in the format mentioned above.See the below ETL code where we fetch employee details from the above data.STEP1: Read Emp data using the “CSV file Input”. See the below SS.Here,…