topic Re: Excel table transformation in QlikView https://community.qlik.com/t5/QlikView/Excel-table-transformation/m-p/639723#M234541 <HTML><HEAD></HEAD><BODY><P>Unfortunately I cannot load it from source. I was provided this excel file and need to add it to the data model..</P></BODY></HTML> Tue, 20 May 2014 12:58:39 GMT 2014-05-20T12:58:39Z Excel table transformation https://community.qlik.com/t5/QlikView/Excel-table-transformation/m-p/639721#M234539 <HTML><HEAD></HEAD><BODY><P>I have to add data from an excel sheet into my QlikView document.</P><P></P><P>When I choose the file and click on transform this is what I get:</P><P></P><P><IMG alt="3.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59211_3.JPG.jpg" style="width: 620px; height: 330px;" /></P><P></P><P>I need to origin country and assigned users to repeat in order to load the data correctly.</P><P></P><P>Is there a simple way of correcting this data, rather than copy and paste before I load the document?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 20 May 2014 12:41:00 GMT https://community.qlik.com/t5/QlikView/Excel-table-transformation/m-p/639721#M234539 2014-05-20T12:41:00Z Re: Excel table transformation https://community.qlik.com/t5/QlikView/Excel-table-transformation/m-p/639722#M234540 <HTML><HEAD></HEAD><BODY><P>Is this sheet a pivottable? If so, you might want to load from the data source instead.</P></BODY></HTML> Tue, 20 May 2014 12:45:36 GMT https://community.qlik.com/t5/QlikView/Excel-table-transformation/m-p/639722#M234540 m_woolf 2014-05-20T12:45:36Z Re: Excel table transformation https://community.qlik.com/t5/QlikView/Excel-table-transformation/m-p/639723#M234541 <HTML><HEAD></HEAD><BODY><P>Unfortunately I cannot load it from source. I was provided this excel file and need to add it to the data model..</P></BODY></HTML> Tue, 20 May 2014 12:58:39 GMT https://community.qlik.com/t5/QlikView/Excel-table-transformation/m-p/639723#M234541 2014-05-20T12:58:39Z