I need to implement a kind of “blackist” with some logic behind.
I’ve already tried some stuff, but it doesn’t work as required still.
We have a SalesData table and a Blacklist table.
If a customer is in the blacklist table, we need to check the year & month since he is blacklisted. From that date on all of his records should be removed from the table. It must be done in script, playing with the filters is not an option ; )
E.g.101 John Smithis blacklisted since 02-2015. All records after 02-2015 will be removed from the table. Only the record from 01-2015 will stay, because he was not blacklisted on that date. The customer 105 Joshua Sleedge will be removed, too.
I’ve setup an example with all data already in place, so you can play with it.
In the file “01_HowTo_Blacklist-data_load_only.qvw” the data is just loaded. – nothing to do there
In the file “02_HowTo_Blacklist-data_modelling.qvw” we should remove the blacklisted customers. In the load script, if possible (but without playing with filters)