Dataset:It includes flags in column ; flags' value can be 0,1, or null.
AlteryxTool:IN-DB Filter
Description:flag = 1
In the above case, the result is...
TRUE side has rows which have flag=1,
FLASE side has rows which have flag=0.
SO, there're no rows which have flag=null...
Is this a bug in Alteryx? or Specification??
Solved! Go to Solution.
I am unsure of the question, but this will likely depend on your datatype - if it's a Boolean (aka bool), in most cases there's only 1 or 0 available. I would check your databases settings on data types, and confirm what you need out of it.
Thank you for your reply :)
This time, the data type of the flag was set to double.
I would like to know if the IN-DB filter tool(Flase side) does not detect NULL values.
If anyone knows, please let me know...
Hello @aYaNe_o
in-db filter works just like the SQL in a where clause of your database.
Best regards,
Simon
@simonaubert_bd is on the money - if you want it to detect nulls, you need the expression to capture that!
By the way, I see the topic is in designer cloud. Are you sure that's the case? O_o
Thanks for your replies...!
When column have NULL values, I would like to be careful to capture it.
> I see the topic is in designer cloud.
I asked the question in the wrong place...
It should be in the Designer Desktop or General.
@aYaNe_o
Can you try something like that ?
(flag = 1) or (flag is null)
Best regards,
Simon
PS : if you're into in-database, please have a look on the ideas ;) https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/idb-p/product-ideas/label-name/categ...