Hi,
I want to select only the first row where the case number has the oldest date ("Case History Insert GMT Timestamp"). Each case has more than one row with different timestamps. When I run the code below I get the error 'field names must be unique within table'. I will appreciate quick help on this.
Main_3:
load
"Case Case Number",
"Case_Internal_Id",
"Case History Case Id",
"Case Owner Id",
"Case_History_Id",
"Case History Case Id",
"Case History Insert GMT Timestamp",
"Case Case Number" & '-' & "Case History Insert GMT Timestamp" As Key,
resident Main_2
Where Not Exists(Key, "Case Case Number" & '-' & "Case History Insert GMT Timestamp")
Order By "Case Case Number" asc,
"Case History Insert GMT Timestamp" asc;
