Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Match Records from two QVD Files

I have two qvd files with following Fields

QVD 1

IDNO,PRD,CLASS,AMOUNT

QVD 2

IDNO, COUNT

I want to load data from table qvd1 if IDNO exists in table qvd2. Please help me to write the script

1 Solution

Accepted Solutions
kumarkp412
Creator II
Creator II

QVD 1

ID NO,PRD,CLASS,AMOUNT from..........

where exits(IDNO);

Concatenate

QVD 2

IDNO, COUNT

from...........

View solution in original post

7 Replies
PrashantSangle


Hi,

Use exists() in where clause of first qvd

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
upaliwije
Creator II
Creator II
Author

Thanks Max

Could you please write the full script

PrashantSangle

Hi,

Try like this

Final_qvd

Load IDNO as temp_IDNO,

COUNT

from QVD2;

join

load *

from QVD1

where exists(temp_IDNO,IDNO);

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable

Hi,

You can use Keep Keyword to do this

use this Script

LOAD IDNO,

     Count

FROM

D:\Vivek\Community\QVD2.qvd

(qvd);

Left Keep

LOAD IDNO,

     PRD,

     CLASS,

     AMOUNT

FROM

D:\Vivek\Community\QVD1.qvd

(qvd);

Regards,

Vivek

kumarkp412
Creator II
Creator II

QVD 1

ID NO,PRD,CLASS,AMOUNT from..........

where exits(IDNO);

Concatenate

QVD 2

IDNO, COUNT

from...........

upaliwije
Creator II
Creator II
Author

Thanks all

PrashantSangle

Hi,

If you dont want to join two tables

then

Try like this

QVD1:

Load IDNO as temp_IDNO,

COUNT

from QVD2;

QVD1:

load *

from QVD1

where exists(QVD1.temp_IDNO,IDNO);

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂