Load and Transform data

[zwyne]

Hi everyone,

PFA,

I have a challenge with multiple Excel file which are piped delimiter and the data is attached. I require assistance on how to read in data as per the Original sheet and the result  which I am expecting is as the Expected sheet on the attached Sample data.

Your assistance will be highly appreciated.

Thanks

[jaibau1993]

Hi!

what about saving the excel files as .csv and then loading those .csv with "|" as delimiter?

Jaime.