topic Filtering Duplicate Emails in QlikView

Filtering Duplicate Emails

haymarketpaul — Mon, 30 Jan 2012 12:03:25 GMT

Hello

I have 2 separate lists of email addresses (online & bulletin)

Lets say for online i have:

and for bulletin i have:

i need to be able to select email addresses that are either:

1. only online email addresses

2. only bulletin email addresses

3. email addresses that appear in both online AND bulletin lists

Not sure of the best way to handle this in the LOAD script to then display and be able to select either of these scenarios?

swuehl — Mon, 30 Jan 2012 12:58:26 GMT

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 [

];

LOAD *, 'Bulletin' as Type INLINE [

];

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

haymarketpaul — Tue, 31 Jan 2012 11:14:31 GMT

Works perfectly Thanks

was missing this crucial bit...very clever.

if(minstring(Type)=maxstring(Type), only(Type), 'Both') as Type