topic Re: Joining table after using Qualify, UnQualify Statements in QlikView

Joining table after using Qualify, UnQualify Statements

ramanarayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Have attached my QV File (Plz dont change the script). I have loaded using Qualify, Unqualify statements(Used these in this qv to replicate my issue in current DB)...

I have attached one more excel as well with Rank & Name Fields in it... I need to join both the tables with "Rank" column.. Please help

Issue am facing is: Not able to Join tables, bcoz i have used qualify / unqualify and in my first table it is using Prefix for the field names.

Regards

Ram

Re: Joining table after using Qualify, UnQualify Statements

Peter_Cammaert — Fri, 08 Jun 2018 10:57:40 GMT

Then you should JOIN all new fields by renaming them to the prefixed field name versions. Or you can first LOAD & JOIN all source data, and only then QUALIFY-RELOAD in a new RESIDENT table-UNQUALIFY.

Re: Joining table after using Qualify, UnQualify Statements

avkeep01 — Fri, 08 Jun 2018 10:57:59 GMT

You can unqualify multiple fields at once with *. For example UNQUALIFY '%*_key'; or UNQUALIFY '*_KEY';

Or rename fields

RENAME FIELD [Table].[Name] TO [New field name]

Re: Joining table after using Qualify, UnQualify Statements

Peter_Cammaert — Fri, 08 Jun 2018 11:00:55 GMT

BTW the table qualification is immediate. The script engine doesn't wait for a subsequent UNQUALIFY statement because there may be none. That may also cause problems if you try to QUALIFY -> LOAD 1st Table -> CONCATENATE LOAD 2nd Table -> UNQUALIFY. The CONCATENATE LOAD won't produce the expected table layout...