Merge 2 columns in 2 datasets and then join the 2 merged columns to 1 column

[KirstenKa]

This is what I would like to establish, see also attachment

[Zapparoli · Accepted solution]

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