Description
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
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!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Congrats on being the first member upload to the new community Gallery @patrick_digan! woooo hooooo!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Works great, very intuitive to use also. Thank you!
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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?
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Same Issue...
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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".
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
@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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Ahhh the lovely AMP engine check box :). Thank you So much @patrick_digan for prompt response. Appreciate it.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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 calculation
I 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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
@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.