topic Re: Conconate and link the qvds in App Development

Conconate and link the qvds

Sasi3557 — Sat, 16 Nov 2024 04:19:40 GMT

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?

Re: Conconate and link the qvds

jyothish8807 — Mon, 21 Oct 2019 06:19:40 GMT

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,

Re: Conconate and link the qvds

Rojarao — Wed, 23 Oct 2019 04:55:24 GMT

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