Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Conconate and link the qvds

Hi all

i wanted to conconate two qvd’s and then link that qvd with other qvd that is loaded next. While i am doing it is adding all the data from all the qvds.

let say

load

text(sales_id) as _LINK_key

test.qvd

conconate 

test1.qvd

load

text(sales_id) as _LINK_key

access.qvd

Is this right?

Labels (1)
2 Replies
Highlighted
Master II
Master II

Hi Sasi,

try this:

load

text(sales_id) as _LINK_key

from test.qvd;

Concatenate

load *

from test1.qvd;

No Concatenate

load

text(sales_id) as _LINK_key

from access.qvd;

 

Br,

KC

Best Regards,
KC
Highlighted
Contributor III
Contributor III

NoConcatenate
load text(sales_id) as _LINK_key From test.qvd(qvd);
Concatenate
Load * From test1.qvd(qvd);
NoConcatenate
Load text(sales_id) as _LINK_key From access.qvd(QVD);