No load after unqualify*

[#1]

Good afternoon,

I`d like to compare data from two tables A and B with the same structure to find data quality problems (concretely: personnel master data from two SAP clients). I want to use a single field Personalnr to join the two data sets.

So I do

qualify *;

unqualify PersonalNr;

A:

load

PersonalNr,

......;

B:

load

PersonalNr,

......;

unqualify *;

ComparisonTable:

load * resident A;

left join (ComparisonTable)

load * resident B;

drop tables A,B;

Then I do more operations on ComparisonTable.

Now because of the unqualify *; statement, ComparisonTable is not created - why?

Many thanks in advance,

Leonardo

[datanibbler]

Hi,

I gues it is being appended to table A since because of that * it has exactly the same structure as that one?

You have to use the NOCONCATENATE keyword before the LOAD in that case.

HTH

[#3]

Works, thanks!