Issue in Joining 2 qvds

[sayadutt]

Hello,

I am reading data from x number of qvd files using * character.. 

My  qvd data looks like:

Team	Release Month	Release Type	RAG Status	EntryDate
A	Aug	Primary	Amber	8/22/2019

Team	Release Month	Release Type	RAG Status	EntryDate
A	Aug	Primary	Red	8/21/2019

Now I am loading the qvds like below: (with wildcard)

LOAD *
FROM
$(VQVDPath)\Filename*.qvd
(qvd);

The table is created like below: 

Squad/Non Squad Name	Release Type	RAG Status	EntryDate
A	Primary	Amber	8/22/19
A	Primary	Amber	8/21/19
A	Primary	Red	8/22/19
A	Primary	Red	8/21/19

However this is what I want:

Squad/Non Squad Name	Release Type	RAG Status	EntryDate
A	Primary	Amber	8/22/19
A	Primary	Red	8/21/19

[krishna_2644 · Accepted solution]

Hi - When you have multiple qvds with same fields and field name, then the concatenation is automatic.

Please find attached qvw for the script.