Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have ~10 fields in my table and I have records that I want to dedup by 4 fields i.e Owner, Subject, Date and Account only. Below is the syntax that I started to put together that gives me error. Can someone help with the code?
Thanks,
Monica
Unique_Activity:
NoConcatenate
LOAD *
RESIDENT Activity
Where Exists(Owner, Subject, [Date], [Account]);
Drop Table Activity;
Thank you so much for the reply. In your response...I did not quite understand what does 1,1,1,1 and 4,4,4,4 and 5,5,5,5 mean?
Thanks
Monica
load * inline [
Owner, Subject, Date, Account, f5
1,1,1,1,a1
1,1,1,1,a2
4,4,4,4,c1
5,5,5,5,d
9,9,9,9,e1
8,8,8,8,f1
9,9,9,9,e2
8,8,8,8,f2
4,4,4,4,c2
];
yuo wrote
I have several records in my table that are duplicate by Owner, Subject, Date and Account and not duplicate by all the 10 fields.
I made some test data with the first 4 fields (Owner, ....) duplicated and the fifth not duplicated.
Replace f5 with your fields.