topic Re: Take Distinct Key and join Flags from non-distinct in QlikView

Take Distinct Key and join Flags from non-distinct

Mon, 22 Dec 2014 20:08:29 GMT

Basically I want to take a table like this:

and make another table like this, that is only the distinct keys with flags joined to it:

I think there's an easy way to do this but I'm kind of slow today. Any help would be appreciated.

Thanks!

jpapador — Mon, 22 Dec 2014 20:20:18 GMT

If a row can never have a 1 in multiple flags you could Sum the flag fields and group by Key

TableName:

LOAD

Key,

Sum(Flag1) as Flag1,

Sum(Flag2) as Flag2,

Sum(Flag3) as Flag3

Resident data

Group By Key;

Anonymous — Mon, 22 Dec 2014 20:23:28 GMT

Hi,

Table1:

LOAD

Key,

Count(Flag1) as Flag1,

Count(Flag2) as Flag2,

Count(Flag3) as Flag3

Resident Table

Group By Key;

Mon, 22 Dec 2014 22:35:19 GMT

Thanks!