We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Missing input data

yzanferr
7 - Meteor

Hello,

 

I have a sheet with data, but within the same column depending on the day, the values could change.

 

Example.

day 1 - column A has 1, 2,3 and 4

the formula is:  if  1-2 or 3-4

 

day 2 - column A has 1, 2, 3  but no 4

the formula is:  if  1-2 or 3-4 - Now I get an error on Alteryx from trying to use "4" but not having it.

 

Is there a way to use it as a Sumif? For Alteryx to ignore if the data is not coming?

 

Thanks,

Yuri

2 REPLIES 2
FredNajjar
9 - Comet

Hi @yzanferr

 

an equivalent of sumif wouldn't really solve your problem. Bascially, if the field (column 4) is not present in your data source/input then there is nothing to calculate. 

 

The way I see around your issue is to make sure all columns are present when running the workflow, here is an example 

 

FredNajjar_0-1619690206106.png

 

 

PS: if you found my solution useful, please mark this question as resolved. 

 

Cheers, 

FN 

yzanferr
7 - Meteor

Thanks, Fred. It is an elegant solution.

Labels