Discussion board where members can get started with Qlik Sense.
I have the location master table in my database which is like
now i have a transaction table with the field
note: the value in locId, DeliveryPlaceCode and WorkingPlaceCode are refer to location master table
now i i fetch this table in to qlikview
link will be created between the two table with locId and I can easily find out the locationname against each locId
how can I find out the location name for deliverycode and workinplacecode;
Go to Solution.
As Mindaugas said, it would be better to use Mapping Load, here is how the script would look like
(html, codepage is 1252, embedded labels, table is @1);
ApplyMap('MappingTable', locID) as Location_locID,
ApplyMap('MappingTable', DeliveryPlaceCode) as Location_DeliveryPlaceCode,
ApplyMap('MappingTable', WorkingPlaceCode) as Location_WorkingPlaceCode,
(html, codepage is 1252, embedded labels, table is @2);
While connecting location master table with transaction table use Mapping:
Mapping as an Alternative to Joining
Regarding DeliveryPlaceCode and WorkingPlaceCode your database should have the familiar master tables like Location master table.
thanks alot dear