Deduplicating by few fields and not 1 in the load script in data load editor

[#1]

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;

[#2]

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

];

[maxgro]

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.