Blob Example

[calvincarr29]

Can someone provide an example of a blob?

I need to output three branches of my workflow to three separate tabs.

Please don't refer me to the Blob Article. 

[alexnajm · Accepted solution]

You need to create the template file with the three tabs first. That will be read into the blob input tool.

Then your blob output will take the input and output it into whatever new naming you might want. i.e. take Template file and output it as "Report 2024-10-01" with the formatting from the template.

Afterwards, your workflow would be able to output the data to those tabs in the new file, just like the use case you mentioned above. The main thing to note is to define the range in the Output Data tool and select the option "Preserve Formatting on Overwrite". The other important thing is to make sure the blob stuff happens first, THEN the outputting happens second - a Block Until Done tool or Control Containers will help this.

Without more context on what you want to do with the blob, I don't want to build a workflow. Assuming you are referencing the control container blob article, I highly recommend downloading the example here instead (sorry if this is the article you were referencing): The Blob: Reporting That Isn’t From a Horror Film - Alteryx Community. That would be similar to the example I'd build. Good luck!

[calvincarr29]

@alexnajm Thank you for the help. I have a pivot table on another sheet in my template that's linked to the sheets. When I run the workflow the output deletes that sheet. Do you know why?

[alexnajm]

It'll be hard to know without seeing the exact error, but what I'd consider is reproducing the pivot with a Summarize or a CrossTab in your flow and output that to the sheet