Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
The reasons is duplicated record , create issue on display price list as there are 2 record QV does not know which one to display. so i need to find out how many duplicated record in my
database , and i need to manually delete those duplicated record.
I like to know how to add one more expression at the enclosed table , which will indicate all duplicate record with "1" ?
Below are the duplicated record :-
FC9001-0010
FC9002
FC9004
FC9011
Paul
Hi,
Try like this
Chart : Straight Table
Dimension : PART_NO_
Expression: =If(Count(PART_NO_) > 1, Count(PART_NO_))
or if you have part_no with duplicate product groups
=If(Count(DISTINCT [Product Group]) > 1, Count(DISTINCT [Product Group]))
Regards,
jagan.
Hi Paul,
Create a Rowno() in your script so it will create a unique primary key for all the rows, then you can identify your duplicates easily.
Eg:
Load
Rowno() as Sino,
A,
B
from <>;
Regards
KC
How do you decide the duplicacy of records, PART_NO coming more that once? If so, try list box expression:
Aggr(if(Count(PART_NO_)>1,PART_NO_),PART_NO_)
and it gives much more part_nos than you thought.
Hi Paul,
PFA,I hope it help to u
I think you have two different product group for FC9004 Part_no. that is why it is getting two row in your chart.
Try this expression
aggr(NODISTINCT RowNo(),PART_NO_)
Hi Mohit
When i add below into my expression :-
aggr(NODISTINCT RowNo(),PART_NO_)
I am not able make the table list all duplicate record , like FC9004. any advise ?
Paul
Hi Kush,
Yes you are right , that is my problem on my raw data . now i need to list them out , any idea ?
Paul
Hi Tres
Thank you. But how come it never list FC9004 ? As FC9004 have duplicated record .
Paul
Hi Peruma
Thank you very much , your answer very similar to Tres. But why FC9004 is not listed ?
Paul