Tool Explanation with Example

[rohit782192]

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

[JosephSerpis]

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]

@rohit782192 

The Data School - Using a Multi-Row Formula in Alteryx

[grazitti_sapna]

@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!

[rohit782192]

How can we fill these NULL Values

Null	Null Should be 1
2
Null	Null should be 3
4
5
6
Null
Null

[JosephSerpis]

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.