Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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]
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...