Concatenation

[shiveshsingh]

Sales:
LOAD
X,Y,Z
FROM
[$(v(Path)) Sales *.xlsx];

In above code, if there are 5 files with Sales prefixe and 2 of them is having same data.

So will the data concatenate in one table(for 2 same files) or load separately in other table?

[zhadrakas]

if they have the same columns it will concatenate in one table and you will have duplicate data.

[prma7799]

Please check this

Understanding Join, Keep and Concatenate

http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/...

[shiveshsingh · Accepted solution]

Got it, thanks

[prma7799]

Please mark correct or helpful answer if you get your answer.