Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Please help me.
I have following tables and fields;
max_stock:
MainVesselTypeId,
MainVesselId,
stock
Vessel:
VesselId,
Name /// vessel name
VesselType:
VesselTypeId,
TypeName // vessel type name
Now, I want to create composite key connecting MainVesselTypeId with VesselTypeId and MainVesselId with VesselId and want to display vessel type name, vessel name and vessel stock. How can I do this using composite key. Here, I cannot/do not want to use Apply Map function.
Please help me .
Thank You,
Rahul Krishan Goyal
You shouldn't need a composite key as you are linking a single table to a single field, if you rename VesselID and VesselTypeID then both tables (Vessel and VesselType) will be linked to max_stock.
max_stock:
MainVesselTypeId,
MainVesselId,
stock
Vessel:
VesselId as MainVesselId,
Name /// vessel name
VesselType:
VesselTypeId as MainVesselTypeId,
TypeName // vessel type name
Thanks so much for response.
You have to make the relation columns have the same name and the join will work automatically in Qlik sense as Bella done in the script
your tables of MaxStock, Vessel , VesselType will be joined as they are one table automatically,
but also they are still three tables.
Good Luck