Currently I am automating a process in Excel with the filter data table activity. I read the Excel sheet in with read range and stored in a variable with like 500 rows. Now i ran the process and opened the Excel afterwards but the cells I outfiltered got deleted which is not what I wanted. I need it the way you would have it manually that the cells get hidden. I used the filter manually as well and I got an other result when I do it through running the process. The manual result is the right one but it is the same formula/filter. Is it because of the keep and remove? If so, is there another solution?
Here a screenshot:
I hope you can help me out