Start Free Trial

Alteryx Designer Desktop Discussions

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

Tool Explanation with Example

rohit782192
11 - Bolide

Can anyone provide the best way to understand Multifield and Multi row formula tool

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

Hi @rohit782192 looking at the examples of these tools within Alteryx designer or the documentation online are the best ways. However highlevel Multifeild allows you to apply a formula to multiple fields e.g. rounding all your numeric fields to 2dp instead of indivdually rounding all these fields. Multi-Row allows you to apply formulas up and down on a field.

binu_acs
21 - Polaris
grazitti_sapna
17 - Castor

@rohit782192, you can simply click on the tool and then you can click on the open example it will open example workflows.

 

I hope this helps!

 

Thanks!

Sapna Gupta
rohit782192
11 - Bolide

How can we fill these NULL Values

 

NullNull Should be 1
2 
NullNull should be 3
4 
5 
6 
Null 
Null 
JosephSerpis
17 - Castor
17 - Castor

Hi @rohit782192 you would use the multi-row rool in that scenrio and add 1 from the value above in the field in your example.

 

Multi_Row_Null_12072022.JPG

Labels
Top Solution Authors