Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Joining table after using Qualify, UnQualify Statements

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
Highlighted

Re: Joining table after using Qualify, UnQualify Statements

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

Highlighted
Partner
Partner

Re: Joining table after using Qualify, UnQualify Statements

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]

Highlighted

Re: Joining table after using Qualify, UnQualify Statements

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