Join different Data Structure

[george55]

Hi all,

Default Workingplace is Liverpool. Qlik is importing datafiles on a daily basis. In mid of October a new attribut 'Workingplace' was introduced. As before Oct this one attribut was missing in the history, tried to work around by giving the Default value: 'Liverpool' to the Facttable with ApplyMap. Now have 4 entries instead of 2 (see below). Tried with a self LEFT JOIN but no luck. Thanks for your help.

ApplyMap('Map_Workingplace', Workingplace, 'Liverpool') as Workingplace,

Name	Date of Joining	Sum Working Hours	Workingplace
Martin	01.10.2019	100	Liverpool
Martin	01.10.2019	10	London
Martin	-	8	Liverpool
Martin	01.10.2019	0	-

[eliran]

Hi George,

Your method should work, maybe share your full script, perhaps you missed something in your explenation.

Applymap doesnt duplicate rows, so the duplication comes from different place.

Eliran.