Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is what I would like to establish, see also attachment
Hi @KirstenKa
You can create a new field in table one with the combination of both colums like:
[Item Trading Code] & '-' & Code as %KeyCode,
YourOtherFields...
From YourDataset.
You can either join both tables into one using a "Left Join" or simply give both columns the same name so Qlik can do it's natural join.
Remember for Qlik to use a Join both fields need to have the same name.
Let me know if that clears it up.
-Zapparoli
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
Hi @KirstenKa
You can create a new field in table one with the combination of both colums like:
[Item Trading Code] & '-' & Code as %KeyCode,
YourOtherFields...
From YourDataset.
You can either join both tables into one using a "Left Join" or simply give both columns the same name so Qlik can do it's natural join.
Remember for Qlik to use a Join both fields need to have the same name.
Let me know if that clears it up.
-Zapparoli
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics