Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.

binuacs
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