Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
Creator
Creator

Joining table after using Qualify, UnQualify Statements

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

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

View solution in original post

3 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

avkeep01
Partner - Specialist
Partner - Specialist

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]

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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...