This content has been marked as final.
Show 2 replies
-
Re: Filtering Duplicate Emails
Stefan Wühl Jan 30, 2012 10:30 AM (in response to Paul Nockolds)I would suggest that you concatenate both lists, and create a new field to filter the origin, maybe using something like:
INPUT:
LOAD *, 'Online' as Type INLINE [
email
];
LOAD *, 'Bulletin' as Type INLINE [
email
];
RESULT:
NOCONCATENATE LOAD email, if(minstring(Type)=maxstring(Type), only(Type), 'Both') as Type resident INPUT group by email;
drop table INPUT;
corrected script to label first load correctly
-
Re: Filtering Duplicate Emails
Paul Nockolds Jan 31, 2012 6:14 AM (in response to Stefan Wühl )Works perfectly Thanks
was missing this crucial bit...very clever.
if(minstring(Type)=maxstring(Type), only(Type), 'Both') as Type
-