Discussion board where members can get started with Qlik Sense.
I want to make a composite key from two joined tables so that i can use this composite key to join with my 3rd table. Below is the example:
from [LIB://QVD/cm_cmpt_dtl.qvd] (qvd);
INNER Join (cm_cmpt_dtl)
FROM [LIB://QVD/gmf_period_statuses.qvd] (qvd);
Now i want to have a composite key LIKE
PERIOD_CODE&'~'&INVENTORY_ITEM_ID in GMF_PERIOD_STATUSES table
Go to Solution.
load *,PERIOD_CODE&'~'&INVENTORY_ITEM_ID as composite_key_name
drop table cm_cmpt_dtl;
After Join you can Load Resident load and create a composite Key