Discussion board where members can get started with Qlik Sense.
I'm having difficulty joining table 2 to table 1. I've tried a left join but the final table results in duplicate IDs and I'm not sure why. Table 1 has many more different Codes than Table 2.
Table 1: (has more columns than this)
Desired resulting table:
I would use ApplyMap. Maybe something like this :
(html, codepage is 28591, embedded labels, table is @2);
ApplyMap ( 'MapType' , Code , null() ) as Type ,
ApplyMap ( 'MapDecription' , Code , null() ) as Description ,
(html, codepage is 28591, embedded labels, table is @1);
See attached qvf,