topic Re: Several files & concatenate data in App Development https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254692#M25373 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>Well no!<BR />The file formats are not the same.<BR />Moreover, some columns are not the same in different files.</P><P></P><P>Regards</P></BODY></HTML> Tue, 31 Jan 2017 09:39:41 GMT Anonymous 2017-01-31T09:39:41Z Several files & concatenate data https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254690#M25371 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>having several website I have several files. they have the same structure.</P><P>How to concatenate the data use the same filters (particularly for the sites, dates, labels) and accumulate the data quantity and amount in the same graphics?</P><P></P><P>Bruno</P></BODY></HTML> Mon, 30 Jan 2017 08:55:39 GMT https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254690#M25371 Anonymous 2017-01-30T08:55:39Z Re: Several files & concatenate data https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254691#M25372 <HTML><HEAD></HEAD><BODY><P>Hello Bruno,</P><P></P><P>If you have multiple data files with same structure and same extension (e.g. <STRONG><EM>.qvd </EM></STRONG>or <STRONG><EM>.xls</EM></STRONG> or <STRONG><EM>.csv</EM></STRONG>) then use below syntax:</P><P></P><P><SPAN style="color: #000000; font-family: monospace; font-size: 14px; background-color: #fbfbfb;">Data:</SPAN></P><P><SPAN class="hljs-load_statement" style="color: #000000; font-family: monospace; font-size: 14px;"><SPAN class="hljs-keyword" style="color: #0000ff; font-weight: bold;">LOAD</SPAN> *</SPAN></P><P><SPAN class="hljs-load_statement" style="color: #000000; font-family: monospace; font-size: 14px;"><SPAN class="hljs-load_source"><SPAN class="hljs-keyword" style="color: #0000ff; font-weight: bold;">FROM</SPAN> ..\Data\*.qvd <SPAN class="hljs-format_specification">(<SPAN class="hljs-format_specification_items" style="color: #0000ff;">qvd</SPAN>)</SPAN></SPAN>;</SPAN></P><P><SPAN class="hljs-load_statement" style="color: #000000; font-family: monospace; font-size: 14px;"><BR /></SPAN></P><P>This will load all of the QVD files into Data table.</P><P></P><P>Hope this will be helpful.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Mon, 30 Jan 2017 12:40:53 GMT https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254691#M25372 rahulpawarb 2017-01-30T12:40:53Z Re: Several files & concatenate data https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254692#M25373 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>Well no!<BR />The file formats are not the same.<BR />Moreover, some columns are not the same in different files.</P><P></P><P>Regards</P></BODY></HTML> Tue, 31 Jan 2017 09:39:41 GMT https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254692#M25373 Anonymous 2017-01-31T09:39:41Z Re: Several files & concatenate data https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254693#M25374 <HTML><HEAD></HEAD><BODY><P>Hello Bruno,</P><P></P><P>Thank you for your inputs. Would it possible to share some sample data along with current situation and expected results. This will help us further analyze this issue.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Tue, 31 Jan 2017 09:53:20 GMT https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254693#M25374 rahulpawarb 2017-01-31T09:53:20Z Re: Several files & concatenate data https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254694#M25375 <HTML><HEAD></HEAD><BODY><P>Yes,</P><P></P><P>how can I you address files?</P></BODY></HTML> Tue, 31 Jan 2017 16:34:06 GMT https://community.qlik.com/t5/App-Development/Several-files-concatenate-data/m-p/1254694#M25375 Anonymous 2017-01-31T16:34:06Z