topic Re: Flat Files in QlikView https://community.qlik.com/t5/QlikView/Flat-Files/m-p/510002#M190561 <HTML><HEAD></HEAD><BODY><P>Hi Nanda,</P><P></P><P>You can use the below script to load data from a text file.</P><P></P><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">Directory</STRONG><SPAN style="font-size: 8pt;">;<BR /></SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Physician_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Site_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Geo_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">#New_Patients</SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR />Test.txt<BR />(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">txt</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">codepage</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">is</SPAN><SPAN style="font-size: 8pt;"> 1252, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">embedded</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">labels</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">delimiter</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">is</SPAN><SPAN style="font-size: 8pt;"> '\t', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">msq</SPAN><SPAN style="font-size: 8pt;">); </SPAN></P><P></P><P>Please find the attached sample text file.</P><P>Thanks,</P><P>Sibin Jacob.C</P></BODY></HTML> Tue, 12 Nov 2013 05:06:32 GMT sibin_jacob 2013-11-12T05:06:32Z Flat Files https://community.qlik.com/t5/QlikView/Flat-Files/m-p/510001#M190560 <HTML><HEAD></HEAD><BODY><P>How to Connect Flat&nbsp; Files In BI Script ? Anyone Example?</P></BODY></HTML> Tue, 12 Nov 2013 04:50:44 GMT https://community.qlik.com/t5/QlikView/Flat-Files/m-p/510001#M190560 2013-11-12T04:50:44Z Re: Flat Files https://community.qlik.com/t5/QlikView/Flat-Files/m-p/510002#M190561 <HTML><HEAD></HEAD><BODY><P>Hi Nanda,</P><P></P><P>You can use the below script to load data from a text file.</P><P></P><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">Directory</STRONG><SPAN style="font-size: 8pt;">;<BR /></SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Physician_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Site_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Geo_Id</SPAN><SPAN style="font-size: 8pt;">, <BR />&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">#New_Patients</SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR />Test.txt<BR />(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">txt</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">codepage</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">is</SPAN><SPAN style="font-size: 8pt;"> 1252, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">embedded</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">labels</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">delimiter</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">is</SPAN><SPAN style="font-size: 8pt;"> '\t', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">msq</SPAN><SPAN style="font-size: 8pt;">); </SPAN></P><P></P><P>Please find the attached sample text file.</P><P>Thanks,</P><P>Sibin Jacob.C</P></BODY></HTML> Tue, 12 Nov 2013 05:06:32 GMT https://community.qlik.com/t5/QlikView/Flat-Files/m-p/510002#M190561 sibin_jacob 2013-11-12T05:06:32Z