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 Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Multi row formula

Happylife2025
7 - Meteor

I have data with three or more columns with 30 rows. I want to update col3 and row 22 which is max of values in col 3 at row 13 & 18. Also i want to update col1 row 10 with same value as in col 2 at row 25. Can anyone help on this ? Tried using multirow formula but it gives me error that variable not found.

3 REPLIES 3
Deano478
12 - Quasar

@Happylife2025 how you got any data you can share so we can test on what you see

abacon
12 - Quasar

@Happylife2025 Yes please share the data so we can be more helpful - even better would be the workflow with the data so we can further help troubleshoot.

 

Bacon

Happylife2025
7 - Meteor

Here is the workflow with some dummy data.