Can anyone provide the best way to understand Multifield and Multi row formula tool
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.
@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!
How can we fill these NULL Values
Null | Null Should be 1 |
2 | |
Null | Null should be 3 |
4 | |
5 | |
6 | |
Null | |
Null |
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.