Setting rows as fieldnames in pentaho

Asked Mar 01 '17 at 13:37

Active Mar 01 '17 at 13:37

Viewed 36 times

I am importing an excel file that imports as the following:

Highlighted in red is what I want to appear as the fieldnames and first row. However as you can see it creates a new row for field names and keeps in the irrelivant information (not highlighted in red).

I am unsure how to go about doing this?

asked Mar 01 '17 at 13:37

Karen

Do you want to take row with IFS_num = Maximo database fields and use it as header row? Anyway, structure looks a bit weird. – Rudolf Yurgenson Mar 02 '17 at 07:22
yes, it's fine i've figured out a way to do this in a batch file before using pentaho – Karen Mar 02 '17 at 09:00

Setting rows as fieldnames in pentaho

0 Answers0