Skip to main content

If i try to add a dataselection rule my tables stay empty.

Tried allready the selection rule on the table and with an without ‘ ‘ 

If i do the same in the query tool it looks good. Is it a bug?

Using version 6143.1

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.

 


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

 


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 


Thanks it works! 

 

Result 

 

Hi Niels
Despite it working, it is not how your are supposed to do it.

Specifically the value you got in the field with the AND Exchange Part Equal 0.

Instead it is supposed to be done like this.

However the fact that this works, gives you the option to do some things that is not supposed to be possible.


Reply