topic Re: Data Load in QlikView https://community.qlik.com/t5/QlikView/Data-Load/m-p/1275820#M400771 <HTML><HEAD></HEAD><BODY><P>Hi Evan, I tried this and the data has been loaded as in excel:</P><P>LOAD * FROM</P><P>[.\Book1.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1);</P><P></P><P>If you drop the xlsx in QV, this is almost the default script. Maybe there is something different in the real excel file.</P></BODY></HTML> Wed, 01 Feb 2017 21:27:52 GMT rubenmarin 2017-02-01T21:27:52Z Data Load https://community.qlik.com/t5/QlikView/Data-Load/m-p/1275819#M400770 <HTML><HEAD></HEAD><BODY><P>I am attempting to load data into Qlikview from an excel file that is from an automated data offload. The data comes through as an excel table (similar to attached) However, because the data is formatted as a table with each column having pre-built filters, Qlikview does not recognize the file and will not load. Is there a method within the script to convert the data file so that it can be brought in correctly?</P></BODY></HTML> Wed, 01 Feb 2017 20:28:58 GMT https://community.qlik.com/t5/QlikView/Data-Load/m-p/1275819#M400770 evansabres 2017-02-01T20:28:58Z Re: Data Load https://community.qlik.com/t5/QlikView/Data-Load/m-p/1275820#M400771 <HTML><HEAD></HEAD><BODY><P>Hi Evan, I tried this and the data has been loaded as in excel:</P><P>LOAD * FROM</P><P>[.\Book1.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1);</P><P></P><P>If you drop the xlsx in QV, this is almost the default script. Maybe there is something different in the real excel file.</P></BODY></HTML> Wed, 01 Feb 2017 21:27:52 GMT https://community.qlik.com/t5/QlikView/Data-Load/m-p/1275820#M400771 rubenmarin 2017-02-01T21:27:52Z Re: Data Load https://community.qlik.com/t5/QlikView/Data-Load/m-p/1275821#M400772 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Wed, 01 Feb 2017 21:30:16 GMT https://community.qlik.com/t5/QlikView/Data-Load/m-p/1275821#M400772 evansabres 2017-02-01T21:30:16Z