I am running into a problem where the filter data table activity is not working. When I run a sample file (attached) through this workflow, I want it to:
- Delete extraneous columns (working)
- Add a column and populate it with a formula (working)
- Filter out rows where column: “Interested” = No OR “Favorited” = Yes
- Filter out rows where column: “PPD” < 130,000
For some reason the filter does not seem to be removing the rows that do not meet each of the conditions. I have the workflow setup to pass in the name of the sheet (sheetName), file name (fileName), and download path (downloadPath) as arguments that are fed from elsewhere. I had been hard coding them in as default values for testing. I’ve included a sample data file as well.
House_Hunt_Issue.zip (20.6 KB)