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.

[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.