Data selection rule is not working with Mapping Sets

Hi Peter Dijkstra,

I am also using the data-selection rule on one of my tables in my test environment, and it works fine:

You shouldn’t include ‘ ’ in your selection. If you do that the table will be empty. But did you say you also tried without ‘ ‘? 

Hi @Peter Dijkstra

We did some additional testing at it will work when you trigger a full load for that table. In this situation: 

In our situation only a deploy and execution won’t work. Please follow the next steps:

• At table level choose Deploy and Execute
• In the next window choose review tasks

  

   

• Unmark en mark again all the tasks in the overview. 
• Execute

   

Hi Peter

I am not sure I see the issue. If the table is using incremental load it will only filter rows that have not been added yet. So doing as suggested by Wahyudi is what you do.

It did look like you did not have incremental load on the table, so that should work. I think the ‘ around it is what gave the issue.

I made this video https://use.vg/hk0c0g it shows how to create a filter on a incremental load table and one without.

I am not using incremental load.

And as i told before i also tried to use without brackets.

it stays empty right now.

wvermeulen wrote:

Hi @Peter Dijkstra

We did some additional testing at it will work when you trigger a full load for that table. In this situation: 

 

 

In our situation only a deploy and execution won’t work. Please follow the next steps:

• At table level choose Deploy and Execute
• In the next window choose review tasks

  

   

• Unmark en mark again all the tasks in the overview. 
• Execute

   

It stays still empty.

Hi @Peter Dijkstra I will create a support ticket, so we can schedule a screen share to investigate the issue further

Is it also possible to apply one filter with 2 different fields? The filtering below doesn't give the correct result. 

DSA

Niels wrote:

Is it also possible to apply one filter with 2 different fields? The filtering below doesn't give the correct result. 

DSA

 

Hello Niels,

If you click on the first data selection rule, you can add a second one on the right of your screen.

You created now a “OR” selection rule and you can create then a “AND” Selection.

Thanks it works! 

Result 

As a little added detail: if you are adding Data Selection Rules to Incremental tables you will see the Incremental Selection Rule and the Data Selection rule on separate lines, but these are AND-ed together. So take note of the icon to differentiate between the two types.

I’ve similar problem with this:

In the MDW area:

When I deploy and execute the table, it’s empty ¿?

I tried with “ES” and ‘ES’ too.

Hi @rvgfox

Can you try to remove the primary key fields from the MDW table, as well as unguarding the DSA table, in order to troubleshoot further?

Also can you please share a screenshot of the DSA table expanded?

Many thanks