Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kash04kk
Contributor II
Contributor II

Qualify using 2 qvd

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

2 Replies
sunny_talwar

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

its_anandrjs
Champion III
Champion III

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