I have two tables Injury and Participation which has around 30 columns in each table. Now, i want to join Injury with Participation on only one Column (Join on ID). How do i do this? I tried using Concatenate option but since i have the same column names in both the tables for some columns it is joining on those as well but i need the join to happen only on one Column i.e ID.
Can you please help me out
If you want to Join the two tables then concatenate is not the option you should use. Concatenate is like Union in sql. Sounds like you should do a left join:
Field1 AS %Join_ID,
FieldX AS %Join_ID,
QlikView will perform the join on the common fields. You need to make sure you name the ID field the same in the both tables.
Check this out for more on joins and concatenations:
If you have same column names in both your tables, Qlik will automatically associate ur 2 tables using these fields in common.
In fact, for Qlik, the key that associates 2 tables is the FIELD that shares the same NAME btwn 2 tables.
So, what you should do is RENAME these fields so that they won't be the same anymore and NAME your ID field in both tables the same way.
sthing like this :
YourID1 as KEY
load fieldA,field2 as fieldB,fieldC,
YourID2 as KEY
Have you checked this link:
Understanding Join, Keep and Concatenate? It offers a detailed explanation.
Have a look here as well:
A sample app won't really provide any more information than that I am afraid.
Hope it helps.