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.
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.
Something like this:
If(Exists(MemberID), 1, 0) As RepeatFlag,
Or something like this (after having loaded the data into a resident table):
Count(MemberID) As IDCount,
Group By MemberID;
Retrieving data ...