-
Re: Filtering Duplicate Emails
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
Works perfectly Thanks
was missing this crucial bit...very clever.
if(minstring(Type)=maxstring(Type), only(Type), 'Both') as Type
-