Discussion Board for collaboration on QlikView Scripting.
Hey, run into a small problem that I hope is easily solved.
So I've got one table that has TableID, AllocatedWorkerID, ReportedWorkerID.
The Allocated and Reported IDs are linked to the same table, which is Users, and are linked by UserID.
I need to be able to see what user reported the work, and what user has been allocated the work, so I can't just load them both "as UserID" or anything, so I'm a bit stumped at the moment.
Also the database is designed by someone else, and do not have the ability to change the architecture of it.
Thanks for any help.
Go to Solution.
If i understood correctly you want the Actual Names for AllocatedID and ReportedID fields from the User table using UserID field.
If this is the case you can use applymap() function. Something like this:
Applymap('Mapping_Table',AllocatedID,'Missing :'&AllocatedID) as [Allocated Worker],
Applymap('Mapping_Table',ReportedID ,'Missing :'&ReportedID ) as [Reported Worker]
Hope it helps
You can load user Dimension table twice and rename columns.
Then your problem will be solved.
Thanks for answers everyone, but this is the one I tried first and it worked absolutely perfectly.
Thank you so much.