Discussion Board for collaboration on QlikView Scripting.
I need to compare two tables based on MEMBERID. If the MEMBERID match I have to add a flag Yes and if the MEMBERID don't match up its No.
The base table is MailingList table and I have to compare it with the Member table.
I have to add flag in the MailingList table. (Flag: Yes/No)
Go to Solution.
Yes - you need to do exactly as I said. See attached.
,ApplyMap('Map_Member',MEMBERID,'No') AS Flag
Hope this helps,
The Mailinglist table has only selected MEMBERID where as the Member table contains the entire list and so I want the result that only include and compare the Mailinglist MEMBERID and flag(Yes/No) for the same.
Does that make it clear?
I have attached an excel which contains the data and the final output I am looking for.