alteryx check if data is empty or zero
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
187
8 - Asteroid
‎06-16-2022
01:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Help
4 REPLIES 4
17 - Castor
‎06-16-2022
01:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎06-16-2022
02:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎06-16-2022
02:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@187 @Small correction
IIF( IsNull([input data1] Or [input data1] = 0 , [input data2], [input data1])
Kurohits
10 - Fireball
‎06-16-2022
03:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
