We have a situation where we need to filter a data table to remove all rows which contain any value specified in a list of values.
There is a master data table of transactions. Each one has a unique Registration ID (a 7 digit number in this case). We iterate through each transaction and perform a check. If the check is failed, we output the transactions to another data table for rejections. We need to then remove these transactions from the master data table, so they are not processed when they have failed the check. We had the idea of adding the Registration ID to a collection, then using a filter data table activity remove rows where Registration ID = Collection. Needless to say, this doesn’t work.
How can we achieve this? Is there another way? a better way?