Using Alteryx to Populate Blank Excel Template using Batch Macro for Multiple Sheets

Question

I'm trying to build an Alteryx workflow that will populate an Excel file with 4 different sheets.

With how I have the current workflow configured, I can get the first 2 sheets to populate (DFUTOSKU_YS and HIst_KDUK_YS), but I can't get the "Hist_FCST" and "New Exception Report" to populate the respective input data.

When I open the output excel file after running my workflow, Alteryx created 2 new sheets at the end

These were titled "Hist_FCST$D1" and "New_Exception_Report$A$17" which was the sheet+cell combination I wanted Alteryx to start populating.

Copy of Exceptions Automation w Batch Macro for Alteryx Community Post.yxwz

Copy of Exceptions Automation w Batch Macro for Alteryx Community Post.yxzp

Exceptions Automation Batch Macro for Alteryx Community Post.yxmc

Alteryx Community Post.xlsx

binu_acs · Answer

@c-yun Make sure you are not passing any blank lines to the blob input and output tools, also, when you pass the category through the summarise tool, use a filter tool to filter out NULL records before passing the arguments to the batch macro

below are the templates you are creating using the blob tools, but I don't see them used in the subsequent containers

c-yun · Answer

I just checked and it looks like I have it checked already.

Dhrish · Answer

@c-yun You must select preserve formatting in the output tool to preserve formatting and update the value in a specific cell.