Remove duplicate Entries in front end

[swatitomar]

Hi All,

Want to remove the duplicate entries from pivot table.

I have 2 table with multiple fields ,1 table name is A and another one is B .

In both table i have some common fields

like SerialNo,

      Dealer_Code,

      Defect_Codes,

      Partno

there are many more fields in table.

ex i have Claim Date , Failure...... in B table

Now query is: i have 10 rows in A table and 1 row with field value in table B ..

One row is matching in A and B table.

and i want 9 rows data of table A and 1 of table B as same value of one row exist in A and B.

Note: i want i front end not in script.

What will be the expression?

Thanks in Advance.

[swatitomar]

Hey ,

i have tried with

Count(1) and

count( distinct Link_Dealer_Code &Link_SerialNo& Link_Partno&Job_No&Hours_Reading)

Both not working as i want to remove the duplicate line of Job not warranty.

U tried the above 1 in my Attached app?

[avinashelite]

If I understood correctly ..

you have 2 table (which is not shown in the current example app ) and you have few rows in common in both the tables and when the above mentioned selection are made you need the row from one of the tables i.e either from A or B ? if yes then you need to add an Identifier dummy column in both the table like below

Table_A:

'A' as Identifier

....

Table_B:

'B' as Identifier

....

And use this field in the set analysis or as a filter box to get the desired result

Hope this helps you