Hi
This code will create the flag field (assuming ID is a unique key for the data):
// Get the number values that are associated with more than one distinct Point value
T_Numbers:
LOAD number,
Count(ID) As Rows,
Count(DISTINCT Point) As Count,
Concat(DISTINCT ID, '|') As IDList
Resident Data
Group By number;
// Get the Point values that are associated with more than one distinct number value
T_Points:
LOAD Point,
Count(ID) As Rows,
Count(DISTINCT number) As Count,
Concat(DISTINCT ID, '|') As IDList
Resident Data
Group By Point;
// Get the list of IDs that need to be flagged
T_Flag:
LOAD SubField(IDList, '|') As ID
Resident T_Numbers
WHERE Rows >= 2 And Count >= 2;
// Get the list of IDs that need to be flagged
Concatenate(T_Flag)
LOAD SubField(IDList, '|') As ID
Resident T_Points
WHERE Rows >= 2 And Count >= 2;
// Add the flag field to your data table (1 = flag, null = no flag)
Left Join (Data)
LOAD ID,
1 As Flag
Resident T_Flag;
// Clean up
DROP Table T_Numbers, T_Points, T_Flag;
HTH
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
