topic Re: How to manage multiple same data file ? Hi in QlikView https://community.qlik.com/t5/QlikView/How-to-manage-multiple-same-data-file-Hi/m-p/36459#M604368 <HTML><HEAD></HEAD><BODY><P>Hi Marco</P><P></P><P>Thank you very much for your sharing. Can you give me one example pjs .</P><P></P><P>Paul Yeo</P><P>Director</P><P>TDS Technology (S) P/L</P><P>Whatsapp +65 9326 1804</P><P>www.tdstech.com&lt;http://www.tdstech.com&gt;</P></BODY></HTML> Sun, 17 Jun 2018 20:57:20 GMT paulyeo11 2018-06-17T20:57:20Z How to manage multiple same data file ? Hi https://community.qlik.com/t5/QlikView/How-to-manage-multiple-same-data-file-Hi/m-p/36457#M604366 <HTML><HEAD></HEAD><BODY><P>‌</P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">How to manage multiple same data file ?</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;"><BR /></SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">Hi All</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">I have sales order raw data file for :-</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">Company A </SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">Company B</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">Company C</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">Company D</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">My old approach is create 4 similar set of script. And I concatenance all Table into one table. For this I need to use 4 Tab. And need to repeat 4 time for same recode field. Very messy</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">New approach I want to try is using loop . For this the adv is I only using one Tab. For recode same field I only need do once , very neat.</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">May I know it there any better approach ?</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"><SPAN style="font-family: '.SFUIDisplay'; font-size: 23pt;">Paul</SPAN></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P><P style="font-size: 23px; font-family: '.SF UI Display'; color: #454545;"></P></BODY></HTML> Sun, 17 Jun 2018 12:44:12 GMT https://community.qlik.com/t5/QlikView/How-to-manage-multiple-same-data-file-Hi/m-p/36457#M604366 paulyeo11 2018-06-17T12:44:12Z Re: How to manage multiple same data file ? Hi https://community.qlik.com/t5/QlikView/How-to-manage-multiple-same-data-file-Hi/m-p/36458#M604367 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you could use wildcards in your file name as well:</P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Load.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Load.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Load.htm</A></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 17 Jun 2018 19:05:58 GMT https://community.qlik.com/t5/QlikView/How-to-manage-multiple-same-data-file-Hi/m-p/36458#M604367 MarcoWedel 2018-06-17T19:05:58Z Re: How to manage multiple same data file ? Hi https://community.qlik.com/t5/QlikView/How-to-manage-multiple-same-data-file-Hi/m-p/36459#M604368 <HTML><HEAD></HEAD><BODY><P>Hi Marco</P><P></P><P>Thank you very much for your sharing. Can you give me one example pjs .</P><P></P><P>Paul Yeo</P><P>Director</P><P>TDS Technology (S) P/L</P><P>Whatsapp +65 9326 1804</P><P>www.tdstech.com&lt;http://www.tdstech.com&gt;</P></BODY></HTML> Sun, 17 Jun 2018 20:57:20 GMT https://community.qlik.com/t5/QlikView/How-to-manage-multiple-same-data-file-Hi/m-p/36459#M604368 paulyeo11 2018-06-17T20:57:20Z