Batch Macro - Only 1 Line Feeding (D&D Monster Parsing)

Question

Hi Team,

I'm playing with Alteryx in my personal time now trying to skill up. I'm tackling a passion project trying to convert a whole heap of data into nicely formatted markdown files.

Example Output: Using program 'Obsidian.md'

Source Data: Excel File where each 1x row is destined to be 1x output.

Approach:  I've created a batch macro. Feeding in 1x Excel record with 100+ records. Each row is read by the macro and converted into a single markdown document. It saves to a folder picked by the user and saves the file name dynamically.

Testing:  No issues with testing. Operating within the Macro workflow produces 1x file successfully.

Issues: The macro is only running once, producing the first line of the table only.

Workflow Files: See attached

I've read that I need to have a macro output in order to trick the macro into cycling through. That doesn't seem to be working though.

Can anyone point me in the right direction? I've attached a copy of the macro, workflow and source data.

Thanks,

Josh

ConvertExcel_MD.zip

JPlunkett · Answer

bump for help by smart people 😞

JPlunkett · Answer

Thanks Jonathan-Sherman,

I tried that however with no luck.

I wonder if it has something to do with how I output the data. While I input 1x row. Each individual row outputs multiple rows as the data is Transposed from columns into rows in order to replicate the required formatting in a text document.

Jonathan-Sherman · Answer

Hi @JPlunkett,

One thing to be wary of with batch macros is you need to have a browse tool at the end of the macro (not inside the macro but outside). Otherwise you will only see the output of the first iteration or batch in this case.

Kind regards,

Jonathan