Conconate and link the qvds

[Sasi3557]

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?

[jyothish8807]

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

[Rojarao]

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);