topic Re: Duplicate records in data Field in QlikView

Duplicate records in data Field

jagjivvt — Tue, 10 Aug 2021 15:52:38 GMT

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

Re: Duplicate records in data Field

mattphillip — Wed, 11 Aug 2021 11:08:09 GMT

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

Re: Duplicate records in data Field

Kushal_Chawda — Wed, 11 Aug 2021 11:21:04 GMT

@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];

Re: Duplicate records in data Field

jagjivvt — Wed, 11 Aug 2021 11:37:40 GMT

Thank you