I have a bunch of excel files that looks similiarly to something like this:
I have to filter the data by column 2 and 3 before writing it into a new excel, the condition of the filter is that if:
col.2 is 8 AND col.3 is =1,
OR col.2 is 9 AND col.3 >=2
then they belong to the same group and the rest of the data are filtered
The filter data table activity works well only if i have just a single excel, but i have multiple excel all with different number, how do i filter it so that the condition is still:
if col.2 = A and col.3=1 OR
col.2=A+1 and col.3>=2 ?