I need to filter an excel table but exclude one of the names (e.g. Harry) in it with using Filter Table activity. It does a very good job by filtering the given input, but when it comes to exclude one of the items in the list, I couldnt figure out how to do it.
In this example, I can write all the other values except Harry in FilterOptions and its done. But my case is that I dont know the exact values, they are dynamically reproduced in the selected excel.
Any suggestions? If doing this is not possible with this activity, than is there any other best practices?