Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
george55
Partner
Partner

Join different Data Structure

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,

 

NameDate of JoiningSum Working HoursWorkingplace
Martin01.10.2019100Liverpool
Martin01.10.201910London
Martin-8Liverpool
Martin01.10.20190-
Labels (1)
1 Reply
eliran
Creator III
Creator III

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.