Conditional Flag

[hkg_qlik]

Hi,

I have a table with Member ID as field name. Now I want to flag those Member ID's which are repeated in the table (More than once) while loading the table.

Regards,

H

[#2]

While loading the table, order by Member ID, assign 1 to Flag, peek previous Member ID, if it matches the current Member ID, increment Flag by 1 else next Member ID.

[jonathandienst · Accepted solution]

Hi

Something like this:

LOAD MemberID,

     If(Exists(MemberID), 1, 0) As RepeatFlag,

     ...

From Table;

Regards

Jonathan

[jonathandienst]

Or something like this (after having loaded the data into a resident table):

Join(Table)

LOAD MemberID,

     Count(MemberID) As IDCount,

Resident Table

Group By MemberID;

Regards

Jonathan