How to read an excel file with multi-row headers

[Anonymous]

Hi Everyone,

I have an excel file with multiple rows of headers as in the example below. How do I handle this? I need to figure a way to import this later such that I can perform a trow split later. I'd really like for it to have "Januar Sales Un. YTD 2018", "Januar Sales Un. YTD 2017", etc., all in one. 

Thank you!

Michael

[TRF]

You may have a 2 steps approach (this is the easier):

- 1rst tFileInputExcel to get the 2nd line from the input file (header = 1, limit = 1), place the result into a tHashOutput for future reuse of the values

- 2nd tFileInputExcel to get the rest of the file (header = 2)