IN-DB Filter Tool 's behavior

[aYaNe_o]

　  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??

[alexnajm]

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.

[aYaNe_o]

Thank you for your reply :)

This time, the data type of the flag was set to double.

[aYaNe_o]

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...

[simonaubert_bd · Accepted solution]

Hello @aYaNe_o 

in-db filter works just like the SQL in a where clause of your database.

Best regards,

Simon

[alexnajm · Accepted solution]

@simonaubert_bd is on the money - if you want it to detect nulls, you need the expression to capture that!

[simonaubert_bd]

By the way, I see the topic is in designer cloud. Are you sure that's the case? O_o

[aYaNe_o]

@simonaubert_bd  @alexnajm 

Thanks for your replies...!

When column have NULL values, I would like to be careful to capture it.

[aYaNe_o]

@simonaubert_bd 

> 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.

[simonaubert_bd]

@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...