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.

Datetime Tool Error when Input/s is/are empty.

Franzil
8 - Asteroid

I have this entire workflow that is working however, sometimes our inventory is empty and the datetime tool will eventually reset on its own and will cause an error. I hope someone will help me on this. Thank you so much!

2 REPLIES 2
Dhrish
8 - Asteroid

@Franzil could you please elaborate what the error you are getting.

apathetichell
20 - Arcturus

my preternatural powers are telling me that this is a situation where a workflow runs with an input which sometimes contains a datetime field --- and sometimes doesn't. The workflow gets configured for the field --- but then errors when it doesn't have the field --- and then they have to reconfigure the datetime tool.

 

If this is accurate the easiest solution is 1) create a text input tool. 2) add a column in your text input tool  --- but no rows --- and make sure it has THE EXACT NAME OF THE FIELD YOU ARE PASSING TO YOUR DATETIME TOOL. 3) use a select tool to put it in the same datatype as your normal field (ie string) --- thiis is optional. 4) use a union tool --- BEFORE your datetime tool to add your dummy field.

Labels
Top Solution Authors