I have a doubt and I would be glad if someone could help me.
I’m trying to filter a DataTable (Excel Sheet) that has a total of 5 columns, by one of the columns.
That column can have the values A,B or C. I only want to keep the rows with value A and B.
I tried the “Filter” Excel activity but when I do “Read Range” in that sheet after, despites the Filtering he still gets the other values with C in the Column…
Thank you for your attention,