IN-DB Filter Tool 's behavior

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

Hello @aYaNe_o

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

Best regards,

Simon

alexnajm

@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/category%20in%20database/tab/most-kudoed

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703