topic Re: Concatenation in QlikView https://community.qlik.com/t5/QlikView/Concatenation/m-p/4472#M792635 <HTML><HEAD></HEAD><BODY><P>Please mark correct or helpful answer if you get your answer.</P></BODY></HTML> Wed, 24 Jan 2018 10:58:51 GMT prma7799 2018-01-24T10:58:51Z Concatenation https://community.qlik.com/t5/QlikView/Concatenation/m-p/4468#M792631 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Sales:<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">X,Y,Z</SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[$(v(Path)) Sales *.xlsx]</SPAN><SPAN style="font-size: 8pt;">;</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">In above code, if there are 5 files with Sales prefixe and 2 of them is having same data.</SPAN></P><P><SPAN style="font-size: 8pt;">So will the data concatenate in one table(for 2 same files) or load separately in other table?</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Concatenation/m-p/4468#M792631 shiveshsingh 2020-11-25T16:16:04Z Re: Concatenation https://community.qlik.com/t5/QlikView/Concatenation/m-p/4469#M792632 <HTML><HEAD></HEAD><BODY><P>if they have the same columns it will concatenate in one table and you will have duplicate data.</P></BODY></HTML> Mon, 22 Jan 2018 06:43:01 GMT https://community.qlik.com/t5/QlikView/Concatenation/m-p/4469#M792632 zhadrakas 2018-01-22T06:43:01Z Re: Concatenation https://community.qlik.com/t5/QlikView/Concatenation/m-p/4470#M792633 <HTML><HEAD></HEAD><BODY><P>Please check this</P><P></P><P><A href="https://community.qlik.com/thread/39177">Understanding Join, Keep and Concatenate</A></P><P><A href="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/concatenate.htm" title="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/concatenate.htm">http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/concatenate.htm</A></P></BODY></HTML> Mon, 22 Jan 2018 09:24:13 GMT https://community.qlik.com/t5/QlikView/Concatenation/m-p/4470#M792633 prma7799 2018-01-22T09:24:13Z Re: Concatenation https://community.qlik.com/t5/QlikView/Concatenation/m-p/4471#M792634 <HTML><HEAD></HEAD><BODY><P>Got it, thanks</P></BODY></HTML> Wed, 24 Jan 2018 10:38:37 GMT https://community.qlik.com/t5/QlikView/Concatenation/m-p/4471#M792634 shiveshsingh 2018-01-24T10:38:37Z Re: Concatenation https://community.qlik.com/t5/QlikView/Concatenation/m-p/4472#M792635 <HTML><HEAD></HEAD><BODY><P>Please mark correct or helpful answer if you get your answer.</P></BODY></HTML> Wed, 24 Jan 2018 10:58:51 GMT https://community.qlik.com/t5/QlikView/Concatenation/m-p/4472#M792635 prma7799 2018-01-24T10:58:51Z