Discussion Board for collaboration on QlikView Scripting.
I have two tables that I would like to join in a third table:
The link are the values under "Header 2" in TableA, but they do not have to appear in result table.
The values under 22, 23 and 26 with "Posting" are the ones to appear.
Any help will be highly appreciated! Many thanks in advance.
Go to Solution.
[Header 2] as joinfield
(html, codepage is 1252, embedded labels, table is @1);
left([Header 2], 2) as joinfield,
(html, codepage is 1252, embedded labels, table is @2)
where Type = 'Posting';
[Header 2] as Flag Inline
Header 1, Header 2
Left([Header 2],2) as Flag,
Header 2, Type
] Where Type <> 'Head';
Thank you both Massimo and Manish!
I think Massimo Grossi's answer is also correct and he has answered before me, so better if you select his answer as Correct and my one as Helpful.
This could be a true justice to his work also.
done as requested. You are totally right.
Sorry Massimo for my mistake, and thank you both again.