Hello, I have spent a lot of time on this but I could not find a straight answer. Here is what I would like to accomplish:
By using the Desktop Recording mode, I was able to open my excel file, apply the “Filter”, and only select all the rows that match my conditions based on the value from a specific column.
From there, I used “for each row” and “type into” to write each line of another column of interest into notepad.
The issue is that after filtering, I am supposed to only have ten rows, but for some reasons, Uipath does not recognize the new filtered data and keeps reading the data from the original excel file.
I am confused.
Any tip? Thank you!