Box Output 2.5.6 - Create Dynamic Folders and Upload file

[mcha54]

Hi all! I'm struggling to get the Box Output to create a new Box Folder (if it doesn't exist) and then write an Excel file to that folder.

This is what my data looks like:

Folder	Filename	Division	Season	Product Code
/SU26/	A Products	A	SU26	1241431
/SP26/	A Products	A	SP26	214214
/FA26/	C Products	C	FA26	12458

So I would want to see 3 new folders (if they don't already exist) and then 1 file each inside that folder.

Combining the Folder and Filename results in an error "Error while writing to XLSX file"

Should the Box Output be embedded in a macro with a control parameter?

Any suggestions or example workflows?

[apathetichell]

you will definitely need a batch macro - if this is possible.