I need to perform a comparison of rows of my data and I am struggling with the logic/nodes that I need to use.
With reference to the below table, what I need to do is:
Example, I need compare the data in the 2 rows, and if all the rows are the same except [“Type de carton” and “Desc carton” and “box_lab_nbr”] i want to keep the row where [“box_lab_nbr” = 2] .
Once the comparison has been completed, I need to loop through all my table
Hi @itsouss , the Duplicate Row filter should be able to assist you here.
You can choose which columns to include for the duplications check. Have it retain all rows but mark with a “duplicates classifier”. Then split rows between those marked as “unique” and the remainder. Of the remainder (lower port on the row splitter) keep only those where lab_nr=2. Then reassemble as a single table and filter off the duplicates-classifier column.
No need to loop. This will handle the entire table in one go.
Here is a demo that hopefully you can adapt
Partial row duplicates.knwf (15.0 KB)
Thank you for your detailed solution.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.