topic Load Field from the file name in QlikView https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162342#M35866 <HTML><HEAD></HEAD><BODY><P>I have a question.</P><P>is it possible to take excel file name as a field.</P><P>Actually i have lot of files coming in daily basis. i need a field called "Date" where the date column should read from the file name.</P><P>eg. file names (12/02/2009, 1203/2009, . . . .n times)</P><P>* I know how to load data from multiple xls files.</P><P>Please help me...</P><P></P><P></P></BODY></HTML> Mon, 24 May 2010 10:48:08 GMT renjithpl 2010-05-24T10:48:08Z Load Field from the file name https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162342#M35866 <HTML><HEAD></HEAD><BODY><P>I have a question.</P><P>is it possible to take excel file name as a field.</P><P>Actually i have lot of files coming in daily basis. i need a field called "Date" where the date column should read from the file name.</P><P>eg. file names (12/02/2009, 1203/2009, . . . .n times)</P><P>* I know how to load data from multiple xls files.</P><P>Please help me...</P><P></P><P></P></BODY></HTML> Mon, 24 May 2010 10:48:08 GMT https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162342#M35866 renjithpl 2010-05-24T10:48:08Z Load Field from the file name https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162343#M35867 <HTML><HEAD></HEAD><BODY><P>Hi Ranjith,</P><P>You can use <STRONG>Filename() or Filebasename()</STRONG> function to get the file name of the excels.</P><P>-Peterson</P></BODY></HTML> Mon, 24 May 2010 11:01:33 GMT https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162343#M35867 2010-05-24T11:01:33Z Load Field from the file name https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162344#M35868 <HTML><HEAD></HEAD><BODY><P>HI Kevin,</P><P></P><P>its working fine, but the problem is, my file name will be in this format (12-Nov-2009).</P><P>I just want to change the same file name into 'MM-DD-YYYY' format.</P><P>I used the below formula, but its not working properly:</P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P>Date</P><P></P>(Filebasename(), 'MM-DD-YYYY') <B>as</B> Date, //this is the formula... <BR /><BR /> <P></P><P></P><P></P><B>LOAD</B> <BR /><BR /> <P></P></BODY></HTML> Mon, 24 May 2010 11:56:03 GMT https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162344#M35868 renjithpl 2010-05-24T11:56:03Z Load Field from the file name https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162345#M35869 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use below code.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Date(Date#(FileBaseName(),'DD-MMM-YYYY'),'MM-DD-YYYY') as Date, // Untested Code<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>-Peterson</P></BODY></HTML> Mon, 24 May 2010 12:01:34 GMT https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162345#M35869 2010-05-24T12:01:34Z Load Field from the file name https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162346#M35870 <HTML><HEAD></HEAD><BODY><P>Awesome !!!! Thanks a lot. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 24 May 2010 12:15:28 GMT https://community.qlik.com/t5/QlikView/Load-Field-from-the-file-name/m-p/162346#M35870 renjithpl 2010-05-24T12:15:28Z