Can We Change the Column Headers in the Data Load Editor

[llenzly]

Hello. Question for you all. In the data manager, we can alter the header size of excel spreadsheets that have additional rows of useless information above the column headers. Doing that is easy. However, can we remove unwanted rows to adjust the column headers of an excel sheet when we load the data from the load editor? What script do we use to adjust the headers?

[kaushiknsolanki]

Hi,

Can you elaborate more using screenshots or example. 

[settu_periasamy]

Hi,

You can try with 'Enable Transformation Step'.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/File_Wizard_Tra...

[llenzly]

Please review the attached scematic

[rwunderlich · Accepted solution]

The LOAD parameter is "header is n lines".  Take a look at the help for LOAD.

-Rob