Discussion Board for collaboration on QlikView Scripting.
Hello Qlik Master,
I have 2 table, Master and Trans table.
Master table have 2 field :
1. ID (1,2,3)
2. Name ('Alex', 'Diana', 'Lidya')
Trans table have 3 field :
1. Message ('Working in the field is Alex's job', 'His wife name is Diana','Lidya goes to market')
Based on above description, how to create a Name column in Trans table based on Name column in Master table?
Thank you so much
I would try something like this:
Load chr(39) & '*' & concat(distinct Name, '*' & chr(39) & ',' & chr(39) & '*', ID) & '*' & chr(39) as NameList Inline [
let vNameList = peek('NameList', -1, 'Master');
Mapping Load rowno() as RowNo, ID Inline [
Load *, applymap('MapTableToMaster', wildmatch(Message, $(vNameList)), 'n.n') as ID Inline [
Message, Timestamp, Status
Working in the field is Alex's job, 1, A
His wife name is Diana, 2, A
Lidya goes to market, 3, B