Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
MailingList:
MEMBERID
ADDRESS
STATE
COUNTY
I have to add flag in the MailingList table. (Flag: Yes/No)
Member:
MEMBERID
ADDRESS
STATE
COUNTY
Thanks,
H
Map_Member:
MAPPING LOAD
MEMBERID
,'Yes'
From Member....;
MailingList:
LOAD
*
,ApplyMap('Map_Member',MEMBERID,'No') AS Flag
From Mailinglist...;
Hope this helps,
Jason
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?
Thanks
H
I have attached an excel which contains the data and the final output I am looking for.
Thanks,
H
Yes - you need to do exactly as I said. See attached.
Jason