Multi-Row -Field -Column Macro example

[#1]

The Multi Row – Multi Field tool allows you to create or update multiple fields with the ability to reference other rows and columns. It combines the best of the multi-row and multi-field formula tools, plus adds multi-column formula syntaxing. See the word doc and example workflow for more details. After opening the yxzp in alteryx, to use the macro in your own workflows, you will need to either: 1) copy the macro (.yxmc) and 2 supporting files (.yxmc.support) to your workflow directory, or 2) copy the macro (.yxmc) and 2 supporting files (.yxmc.support) to your macro repository.

Updated 2024-11-15: Fixed an issue with Join 37 by changing ColumnNumber in Formula 36 to be an integer instead of double.

Updated 2025-04-28:Fixed an issue when the user references more than 9 rows (ie Row-10 caused an error in priror versions). Thanks to @Ken_Black! 

[LeahK]

Congrats on being the first member upload to the new community Gallery @patrick_digan! woooo hooooo!

[nathanjeffs]

Works great, very intuitive to use also. Thank you! 

[paolobottiglione]

Hi all i tried everything to make this work but no luck. Even by changing the format to string the same error come up "Tool 37 double fields can only be joined to others double fields". Anyone experience this?

[JeffJeffrey12]

Multi-Row -Field -Column Formula (13) Tool #37: Double fields can only be joined to other double fields.

Same Issue...

[sowjanyayinti]

Can this macro not be used to do a regex match on multiple dates? I am getting the same error someone mentioned above - "Tool 37 double fields can only be joined to others double fields".

[patrick_digan]

@paolobottiglione @JeffJeffrey12 @sowjanyayinti  Sorry about that! I've updated the macro to fix that issue. You'll need to redownload it. That issue should only have been appearing when AMP was being used. It has stricter requirements for joins. The macro should now work when AMP is turned on.

[sowjanyayinti]

Ahhh the lovely AMP engine check box :). Thank you So much @patrick_digan for prompt response. Appreciate it.

[Ken_Black]

Hi Patrick,

As usual, brilliant work!

I have 1-minute data and tried to construct a 31-minute moving average for multiple columns. I discovered that the limit for the number of forward or backwards facing rows was 9. When I added Row+10 or Row-10, an error gets triggered. I have attached three sreen shots to show you what happens with respect to the error. I also included a plot of Tableau vs Alteryx computed 19-minute moving average to show that your function works correctly up to +/- 9 rows of data.

I took a look at the macros you developed for this, and I could likely determine what is causing the row numbers to be limited to one digit. However, I don't have time right now to do that. I just wanted you to know that this problem this exists. If and when I fix the problem, I'll let you know. 

Your work is much appreciate by me!

Ken

The complete 31 minute moving average calculationI added Row+10, which triggers the error shown in the next graphic. If the formula is limited to +/- 9 rows (a 19 minute running average), it works fine.Error: The Row+10 field is an unknown variable.

[patrick_digan]

@Ken_Black Thanks for pointing that out! I added Select 97 to change a string to integer. I was then able to reference row-10 in a quick test I ran. I re-uploaded the yxzp file. Note that it was just the main yxmc that I changed, both the .support files didn't need any changes.