In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

alteryx check if data is empty or zero

187
8 - Asteroid

Hi Alteryx engineer,

 

i have two input data, both are numberic, my logic is if input data 1 is null or 0, i will use input data 2 , otherwise use input 1, is there any quick way implement this without having control parameters?

 

 

4 REPLIES 4
DataNath
17 - Castor
17 - Castor

Hey @187 do you mean you just have 2 rows? If so you could just use a filter with the following:

 

!isnull([Numeric field]) AND [Numeric field] !=0

 

If not, are you able to supply some sample data or a mock workflow?

binuacs
21 - Polaris

@187 

 

IIF( IsNull([input data1] Or [input data = 0 , [input data2], [input data1])

binuacs
21 - Polaris

@187 @Small correction

 

IIF( IsNull([input data1] Or [input data1] = 0 , [input data2], [input data1])

Kurohits
10 - Fireball

I hope this will help. Attached workflow for your reference. Let me know if this works for you. 

 

Kurohits_0-1655374823844.png

 

Labels
Top Solution Authors