Data Mapping & Data Transformation

Hello All,

I am new to using KNIME, went thorugh the basic stufss and i can do the basic operations using KNIME.

I am working on Data Migration of Engineering system from one application to another application, planning to use KNIME to perform Data Mapping and Data Transofmration.

I have excel sheet like below with different Types and attributes, and then i have 2 other excel sheets , 1st excel has like of columns that are not required to be migrated for each type, ( so i need to delete them from my first sheet)

2nd excel will have mapping for Types and attributes, for the types, the row values has to be changed based on the mapping sheet and for attributes column headers has to be changed based on the mapping file.

Sample Input File:

Any guidence will be much appreciated.

Thanks