Qualify using 2 qvd

[kash04kk]

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

[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]

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