topic Re: No load after unqualify* in QlikView

No load after unqualify*

Fri, 29 May 2015 11:08:15 GMT

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;

load

PersonalNr,

......;

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

Re: No load after unqualify*

datanibbler — Fri, 29 May 2015 11:10:47 GMT

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

Re: No load after unqualify*

Fri, 29 May 2015 11:26:42 GMT

Works, thanks!