I’m currently working with dataTables and I’m having trouble deleting rows based on conditions.
For example I have the following dataframe :
I want to remove duplicates rows based on the Columns BASE_TTW and IMME but I want to keep the one which has “Ligne Valide” in the “Traitement” column.
For example the final dataTable should look like that :
first I remove duplicates for all columns.
Then I tried to create different dataTable using filter datatable activity and remove duplicate rows but it seems that that last activity can’t take conditions.
Is there a way to integrate SQL conditions in?
Maybe a solution using with Excel activity could be easier?
If you guys have any idea, it would be grateful to share it.
Thanks in advance,