Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Works, thanks!