Duplicate records in data Field

[jagjivvt]

Hi

I have a field called Invoice ID, in this the field the Invoice ID could appear more than once. if it does, I need to mark annotate with an abbreviation, either numerical or alpha. 

thanks

Vijay

[mattphillip]

Something like this?
LOAD,
InvoiceID,
If(InvoiceID=InvoiceID, "Annotate","") as Annotation
From ...

[Kushal_Chawda · Accepted solution]

@jagjivvt  may be like below

Data:
LOAD *
FROM Table;

left join(Data)
LOAD [Invoice ID],
     if(Cnt_Invoice>1,'Duplicate','Non-Duplicate') as Flag;
LOAD [Invoice ID],
     count([Invoice ID]) as Cnt_Invoice
resident Data
group by [Invoice ID];

[jagjivvt]

Thank you