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.
SOLVED

How to add missing fields as Null when they are not present

Gandalf_NotGrey
8 - Asteroid

Hello

I have a workflow where I am creating four fields using input data. These four fields are then used for a set of calculations. When any of these field is not present, the formula tool errors out. I want to create the missing fields and replace them as Null().

If you see the attached sample, I tried this by adding the missing fields as through a Text Input tool and Union it with the main flow. But this only works when all four fields are not present in the main workflow. In my case, one of two or three of the fields can be not present and I need to add only those ones are Null or empty. How can I do this?

Thanks.

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

I think you're doing it correctly. Either delete the empty row in the dummy Text Input (or if you always want one row even if no data in the main workflow branch then you could sample the first row).

 

 

Gandalf_NotGrey
8 - Asteroid

Thanks @PhilipMannering - I removed the empty row and it worked. Should've just kept the columns.

Labels
Top Solution Authors