https://community.qlik.com/t5/QlikView/Load-and-Transform-data/m-p/1576967#M740454 <P>Hi everyone,</P><P>PFA,</P><P>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&nbsp; which I am expecting is as the Expected sheet on the attached Sample data.</P><P>Your assistance will be highly appreciated.</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT zwyne 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Load-and-Transform-data/m-p/1576967#M740454 <P>Hi everyone,</P><P>PFA,</P><P>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&nbsp; which I am expecting is as the Expected sheet on the attached Sample data.</P><P>Your assistance will be highly appreciated.</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Load-and-Transform-data/m-p/1576967#M740454 zwyne 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Load-and-Transform-data/m-p/1576986#M740455 <P>Hi!</P><P>what about saving the excel files as .csv and then loading those .csv with "|" as delimiter?</P><P>Jaime.</P> Mon, 06 May 2019 14:12:59 GMT https://community.qlik.com/t5/QlikView/Load-and-Transform-data/m-p/1576986#M740455 jaibau1993 2019-05-06T14:12:59Z