Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The LOAD parameter is "header is n lines". Take a look at the help for LOAD.
-Rob
Hi,
Can you elaborate more using screenshots or example.
Hi,
You can try with 'Enable Transformation Step'.
The LOAD parameter is "header is n lines". Take a look at the help for LOAD.
-Rob