I was trying to apply multiple filters, on my excel sheet via StudioX. I used 2 steps for this. Use the excel sheet and add filter 1. Use the excel sheet add filter 2. But it only considered filter 2 and removed filter 1. I did not tick on the box stating: “Clear any existing filter”. Please help me!
The Filter activity should be cumulative if you provide the exact same source range. If the sources are different: ie first time you provide Sheet, then you provide a dedicated range, Excel doesn’t know those ranges are the same so it clears the previous filter.
Let me know if this helps.