topic Qualify using 2 qvd in QlikView

Qualify using 2 qvd

kash04kk — Tue, 06 Sep 2016 10:12:52 GMT

Hi,

I'm loading 2 qvd into a single table like this:

Claims:

LOAD Risk_ID,

Sub_Class,

Amount_Paid,

Type

FROM

Claims.qvd(qvd);

LOAD Risk_ID,

Sub_Class,

Amount_Paid,

Type

FROM

Claims_OS.qvd(qvd);

When I use QUALIFY * it makes two separate tables (with fields like Claims.Type and Claims_OS.Type) whereas I want 1 table which should show the fields as Claims.Sub_Class, Claims.Type, etc

Any suggestions please?

Thanks

Re: Qualify using 2 qvd

sunny_talwar — Tue, 06 Sep 2016 23:54:15 GMT

May be try like this:

Tmp_Claims:

LOAD Risk_ID,

Sub_Class,

Amount_Paid,

Type

FROM

Claims.qvd(qvd);

Concatenate (Tmp_Claims)

LOAD Risk_ID,

Sub_Class,

Amount_Paid,

Type

FROM

Claims_OS.qvd(qvd);

Qualify *;

Claims:

NoConcatenate

LOAD *

Resident Tmp_Claims;

UNQUALIFY *;

Re: Qualify using 2 qvd

its_anandrjs — Tue, 15 Nov 2016 20:38:02 GMT

Try wit this

Claims:

LOAD Risk_ID,

Sub_Class,

Amount_Paid,

Type

FROM

Claims.qvd(qvd);

Concatenate(Claims)

LOAD Risk_ID,

Sub_Class,

Amount_Paid,

Type

FROM

Claims_OS.qvd(qvd);

QUALIFY *;

NoConcatenate

Final:

LOAD * Resident Claims;

DROP Table Claims;

UNQUALIFY *;

Regards

Anand