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?
