Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables that I am trying to join together. There is a common field, but the names are not the same. I want to QUALIFY the smaller table, but UNQUALIFY the field that will be used for the join. At what point in the script do I change the field name from the smaller table to match that of the larger table? The field name in the smaller table, BRData, is PC and the field name in the larger table. Main Data, is Profit Center.
QUALIFY *;
UNQUALIFY [PC];
BRData:
LOAD
Item,
Material,
Vendor,
Requisitioner,
Description,
[PC] as [Profit Center]
FROM
[D:\Qlik\Data\BR Data FY19.xlsx]
(ooxml, embedded labels, table is [Download]);
@cliff_clayman your post has been removed fro spam
I am not an expert developer, but the mistake here might be having used [PC} instead of [Profit Center], I cannot recall which name we check, but if things are not working, try switching things to the alias and see if it then works for you...
If that does not, and you still need help, you may want to include script for both tables etc., so folks can see the entire thing, that way someone should be able to find the culprit for sure and let you know the correct fix.
Regards,
Brett