I am using kettle 4.0.1 .I have an excel file with this format
which I want to convert to :
Line1 ABC Category1
Line2 XYZ Category1
Line3 ASD Category2
Can anyone help me how can I achieve this using kettle.