topic Loading files from folder using LOAD DISTINCT Filename in QlikView https://community.qlik.com/t5/QlikView/Loading-files-from-folder-using-LOAD-DISTINCT-Filename/m-p/1349294#M840790 <HTML><HEAD></HEAD><BODY><P>I currently have an excel document in a folder with 3 tabs containing data. Using the Load distinct function, Qlikview returns the filename.</P><P>However, as soon as I add another tab to the excel document, Qlikview returns a null value for the filename. Any idea what I am doing wrong?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Loading files from folder using LOAD DISTINCT Filename https://community.qlik.com/t5/QlikView/Loading-files-from-folder-using-LOAD-DISTINCT-Filename/m-p/1349294#M840790 <HTML><HEAD></HEAD><BODY><P>I currently have an excel document in a folder with 3 tabs containing data. Using the Load distinct function, Qlikview returns the filename.</P><P>However, as soon as I add another tab to the excel document, Qlikview returns a null value for the filename. Any idea what I am doing wrong?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-folder-using-LOAD-DISTINCT-Filename/m-p/1349294#M840790 2020-11-25T16:16:04Z Re: Loading files from folder using LOAD DISTINCT Filename https://community.qlik.com/t5/QlikView/Loading-files-from-folder-using-LOAD-DISTINCT-Filename/m-p/1349295#M840791 <HTML><HEAD></HEAD><BODY><P>Post sample data so that it is easy to understand..</P></BODY></HTML> Tue, 02 May 2017 14:27:03 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-folder-using-LOAD-DISTINCT-Filename/m-p/1349295#M840791 Anonymous 2017-05-02T14:27:03Z Re: Loading files from folder using LOAD DISTINCT Filename https://community.qlik.com/t5/QlikView/Loading-files-from-folder-using-LOAD-DISTINCT-Filename/m-p/1349296#M840792 <HTML><HEAD></HEAD><BODY><P>Please post your script.</P><P></P><P>-Rob</P></BODY></HTML> Wed, 03 May 2017 11:35:06 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-folder-using-LOAD-DISTINCT-Filename/m-p/1349296#M840792 rwunderlich 2017-05-03T11:35:06Z