Hi Wong, tables in Qlik are joined using fields names: two tables with the same field are joined using that field values.
In your case you can rename EXT_ORG_ID to LAST_SCH_ATTEND, and use Join to keep the values in one table:
LOAD [FieldNames] From...;
LOAD EXT_ORG_ID as LAST_SCH_ATTEND, LS_SCHOOL_TYPE...
This are my tables
ID CAREER CAR_NBR LAST_SCH_ATTEND 1000006 MIT 0 E0000000001 1000008 MAR 0 E0000000002 1000008 UGRD 0 E0000000002 1000010 PHD 0 E0000000003 1000010 UGRD 0 E0000000003
EXT_ORG_ID EFFDT EFF_STATUS LS_SCHOOL_TYPE E0000000001 1905-01-01 00:00:00.000 A UNV E0000000002 1905-01-01 00:00:00.000 A UNV E0000000003 1905-01-01 00:00:00.000 A UNV E0000000004 1905-01-01 00:00:00.000 A HIGH SCHOOL E0000000005 1905-01-01 00:00:00.000 A COLLEGE
I tried renaming the EXT_ORG_ID to LAST_SCH_ATTEND and left joined, but the result gave many ID and LS_SCHOOL_TYPE duplicates. Any ideas?
Hi, in this tables I already see duplicates por 1000008 and 1000010, caused by different careers, if the table EXT_ORG has the field EXT_ORG_ID as uniquie identifier, and this field is the only one with the same name between both tables, there should be no duplicates created by join.
You can also use a mapping table to avoid creating duplicates with join but I would try to look the real reason of the duplicates to undertand whats happening.
When you are wanting to join one field from one table to another in Qlik you should ideally use an apply map.
If there is more than one field then you would look at joining.