Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

IN DB Filter

10005970
6 - Meteoroid

Hi

I need to apply an in DB filter that will extract missing dates (where the date field is empty) can anyone help with this?

 

thanks in advance

 

Andy

5 REPLIES 5
Zas3nfkb
8 - Asteroid

I would configure the field to be where [Date field] IsNull or [Date Field] IsEmpty

atcodedog05
22 - Nova
22 - Nova

Hi @10005970 

 

Use a indb filter tool

atcodedog05_0-1644930589786.png

 

And configure like this

atcodedog05_1-1644930621201.png

 

Hope this helps : )

 

 

apathetichell
18 - Pollux

just chiming in to say that @atcodedog05  is 100% correct - and correctly formatted the field syntax for In-DB.

10005970
6 - Meteoroid

Thanks that did it.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @10005970 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels