Joining table after using Qualify, UnQualify Statements

[ramanarayan]

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

[Peter_Cammaert · Accepted solution]

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]

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]

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