Macro Help

stevenlsj789

Hello- I was able to use the RegEx to extract the first N words in a field with help from this forum yesterday. Today I am just trying to make this a Macro so I can reuse that later for my team. However my struggle is when I save the macro (in zip folder attached below) and later create a new workflow using different input file that my macro won't work. (I.e. the configuration for my marco will only include the fields in my original files). Can someone please help me with this? This is my first time making a Marco. Thank you so much! 

Extract the First N Words.zip

lmorrell

Hi @stevenlsj789 

Workflow zip is attached

Turning a macro from a static macro to something more dynamic can always be tricky - and lots of people have their own ways of dealing with it. However, one way to make the Macro more usable by a team member is to select "Show Field Map" in the Macro Input Tool so that we can map the fields within the Macro Configuration window. This will require EVERY field in your example dataset originally entered in the Macro Input Tool to be mapped to the Incoming datastream. However, if we only have a single column within the example, then processing will occur to only the mapped columns and leave the unmapped columns untouched - allowing the calculation to get appended as a new column. The result of doing this is as below:

Additionally, I made some minor tweaks to the macro so that the User Input number updated in the RegEx formula and that the macro functioned as intended. 

Hope this helps! 

Macro Help.yxzp