Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zwyne
Creator
Creator

Load and Transform data

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

 

 

1 Reply
jaibau1993
Partner
Partner

Hi!

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

Jaime.