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.
