How can i do in the filter data table activity for specify that i want to remove all the line which contain V1105 and contain “DLIV” in the row before the bloc. And if the “if activity” is correct, remove also the row who contain “5”.
I specify that several bloc can have the code “DLIV” but every bloc can have the duo “DLIV” + “V1105”.
A bloc begin always with “1000” → F0 B7 1000
And finish with “5” → M2 B7 5
I have 3 blocs in this sample.
I have a excel input like that : Input.xlsx (8.4 KB)
This file represente the line that i have to treat in the first excel file (Forum UiPath). DL - IV - 41087 for example. I have to remove all the bloc.
We found this informations here : 1000 140819FRT3ORDLIV (C1 in excel) and C3-4-5-6-… for “41087”.
I need to do a first research : DLIV to know each bloc have it (because several bloc can have DLIV. The 3 blocs in the sample have DLIV).
A second research to know each bloc which have DLIV, have the number 41087.
And after that, remove the bloc which have the duo DLIV and 41087. All the bloc (example of a bloc above).