alteryx check if data is empty or zero

[187]

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?

[DataNath]

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]

@187 

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

[binuacs]

@187 @Small correction

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

[Kurohits]

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