Assistance trying to use a template file for multiple outputs based on column values

I've seen multiple posts on here regarding the usage of blobs to accomplish this task but I'm having difficulty following along, so if someone can assist. I've attached two files. The first is the input data that is our data source. The second file is the template I want to use for the output. The goal is to create one output file for each Driver listed in the Input file. The drivers are dynamic and can change from one period to the next. The workflow should use the input file to populate the correct fields in the output file using the template. This includes header data in cells B2 & B3 and detailed data beginning with cell A6 in the template file.

Input Data.xlsx

Driver Pay Statement Template.xlsx

Developer

Accepted answers

Qiu

@bdoogan
I refer this thread and put the workflow inside a Batch Macro so each drive gets an output.
https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

0115-bdoogan.yxzp

All comments

Qiu

@Carolyn
I believe you can help for this problem 😁.

Qiu

0115-bdoogan.yxzp

bdoogan

I'm getting a message that this was created in a new version of Alteryx Designer but when I check for any updates it says I'm on the latest version. I'm running version 2025.1.2.79. Which version did you use to create this workflow? Is there a similar solution for the version I'm running?

bdoogan

So I tried to migrate this solution to the folder and link it to my actual data set but am encountering an issue when running the .yxmd workflow. See attached error messages. When I run this workflow via the .ymxc file, it successfully creates the one sample file as expected. Any ideas?

Error Messages at Runtime.docx

ccanterman

Hi @bdoogan - That error is telling us that something is going wrong with Tool #3 within the macro. Typically when troubleshooting, I'll open the macro and do a Ctrl+F, type in 3, and it'll take me right to the tool. What this message is telling us is that the macro is expecting the FIELD called "Brown, Joseph" and not finding it (not a field with that value). Without seeing what you're doing, my guess is you're using a Cross Tab Tool and turning the people's names into column headers (but that's just a guess from how I usually run into this issue).

Are you able to share your workflow as a yxzp (Designer -> Options -> Export workflow) with dummy data? Also, what tool is #3 in your macro?

Error:

2026-01-18 07_14_55-Error Messages at Runtime.docx - Protected View - Word.png

bdoogan

Rebuilt it from scratch and I seem to have eliminated this issue. Thanks for everyone's assistance. I'll mark the detailed example provided to me as the final solution.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703