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 Jyothish
I try to use expression to do it first , till i have no choice , then i will try load script.
Paul
Hi Paul,
I have a doubt, why do you want to delete the duplicates since the product group associated with Part no is different?
Use Sum(Listprice) as expression.
Regards
KC
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,
In my application listing FC4009.
PFA
Please see the attached.
I have created one table for Duplicate records
Hi Jagan
Your answer , so far it the best .Because you can display duplicated rec on table.
Thank
Paul
Hi Perumai
Okay after i change the presentation Tab number of line = 9999 , i can view FC9004.
Thank you.
Paul
Hi Kush
Thank you very much , your also working.
Paul
Hi Jyothish
you ask a very impt question , because it is very hard for me to remove manually all duplicated record. as i have too many duplicated record.
can i show you my actual QV doc , and you can advise me how to modify my expression , so that FC9004 can be display out ?
Paul