topic Draw data from multiple text files in QlikView https://community.qlik.com/t5/QlikView/Draw-data-from-multiple-text-files/m-p/164435#M37129 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P>I am drawing data from multiple text files from a specific folder.<BR />Is there a way of drawing the actual file name in as one of the columns? The idea what I have is as follows, but I do not know how to write it in QV language;</P><P></P><P><BR />Load<BR />Column1,<BR />Column2,<BR />Column3,<BR />-File Name- AS Column4</P><P>from Folder\*.xls (biff, embedded labels, table is Sheet1$);</P></BODY></HTML> Fri, 29 Oct 2010 10:35:47 GMT 2010-10-29T10:35:47Z Draw data from multiple text files https://community.qlik.com/t5/QlikView/Draw-data-from-multiple-text-files/m-p/164435#M37129 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P>I am drawing data from multiple text files from a specific folder.<BR />Is there a way of drawing the actual file name in as one of the columns? The idea what I have is as follows, but I do not know how to write it in QV language;</P><P></P><P><BR />Load<BR />Column1,<BR />Column2,<BR />Column3,<BR />-File Name- AS Column4</P><P>from Folder\*.xls (biff, embedded labels, table is Sheet1$);</P></BODY></HTML> Fri, 29 Oct 2010 10:35:47 GMT https://community.qlik.com/t5/QlikView/Draw-data-from-multiple-text-files/m-p/164435#M37129 2010-10-29T10:35:47Z Draw data from multiple text files https://community.qlik.com/t5/QlikView/Draw-data-from-multiple-text-files/m-p/164436#M37130 <HTML><HEAD></HEAD><BODY><P>there is a function called filename() in qlikview.</P><P></P><P style="margin-left:40px;">Load * filename( ) as X from</P><P style="margin-left:40px;">C:\UserFiles\abc.txt</P></BODY></HTML> Fri, 29 Oct 2010 10:42:22 GMT https://community.qlik.com/t5/QlikView/Draw-data-from-multiple-text-files/m-p/164436#M37130 2010-10-29T10:42:22Z