Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
20 - Arcturus

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
Top Solution Authors