Discussion board where members can get started with Qlik Sense.
I have one table with columns like below
Programmer these two having the values ID's
and I have a master table to map this
"UserID" as Engineer,
"UserID" as Programmer,
when I load this am getting synthetic key how can I resolve this?
here in master table all user names belongs to eng and prog are there.
Try a Mapping Load and then ApplyMap(), maybe something like but I not sure I have properly understood your underlying data and I have typed the below free hand so it may have typo's.
ApplyMap ( 'MapUserName' , [Engineer] , null() ) as [Engineer Name] ,
ApplyMap ( 'MapUserName' , [Programmer] , null() ) as [Programmer Name]