topic Re: Match Records from two QVD Files in QlikView

Match Records from two QVD Files

upaliwije — Wed, 27 Aug 2014 04:45:40 GMT

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

Re: Match Records from two QVD Files

PrashantSangle — Wed, 27 Aug 2014 04:49:56 GMT

Hi,

Use exists() in where clause of first qvd

Regards,

Re: Match Records from two QVD Files

upaliwije — Wed, 27 Aug 2014 04:59:50 GMT

Thanks Max

Could you please write the full script

Re: Match Records from two QVD Files

PrashantSangle — Wed, 27 Aug 2014 05:13:06 GMT

Hi,

Try like this

Final_qvd

Load IDNO as temp_IDNO,

COUNT

from QVD2;

join

load *

from QVD1

where exists(temp_IDNO,IDNO);

Regards,

Re: Match Records from two QVD Files

Wed, 27 Aug 2014 05:24:46 GMT

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

Re: Match Records from two QVD Files

kumarkp412 — Wed, 27 Aug 2014 05:25:59 GMT

QVD 1

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

where exits(IDNO);

Concatenate

QVD 2

IDNO, COUNT

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

Re: Match Records from two QVD Files

upaliwije — Wed, 27 Aug 2014 08:07:19 GMT

Thanks all

Re: Match Records from two QVD Files

PrashantSangle — Wed, 27 Aug 2014 08:07:56 GMT

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,