Forum Discussion

rbeneteli's avatar
rbeneteli
Frequent Visitor
7 years ago
Solved

How to eliminate both duplicates lines

Hello guys, my problem is the one in the subject, it looks like simple but i can't find a solution, so in my table if I have a duplicate line they are errors and I would like to eliminate both, how c...
Need Help
  • Vvelarde's avatar
    Vvelarde
    7 years ago

    rbeneteli

     

    Hi,

     

    1--Do a Merge with the Same Table

     

    Fruits With Fruits

     

    2 --When Expand the Table Select Aggregate - Count of Fruits

     

    3--Filter This New Column is equal to 1.

     

    Regards

    Victor

     

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
7 years ago

rbeneteli

 

Hi,

 

1--Do a Merge with the Same Table

 

Fruits With Fruits

 

2 --When Expand the Table Select Aggregate - Count of Fruits

 

3--Filter This New Column is equal to 1.

 

Regards

Victor

 

 

rbeneteli's avatar
rbeneteli
Frequent Visitor
7 years ago

Vvelarde

 

Thanki you, it worked