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
Best answer by Thomas Lind
View original
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
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:
+5
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
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:
It stays still empty.
+5
Hi
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
+7
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.
+1
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.
+5
Hi
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
+5
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
