Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jagjivvt
Creator
Creator

Duplicate records in data Field

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

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

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

 

View solution in original post

3 Replies
mattphillip
Creator
Creator

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

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

 

View solution in original post

jagjivvt
Creator
Creator
Author

Thank you