Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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