BLOB - Workflow to output Multiple tabs_files

[PassION_es]

Dear Alteryx Blob expert,

I have a case in which I want the output to be formatted as it is (see input_BLOB tab) and populate all cells in pink font.  I would like to output multiple tabs, with similar format, headers, table etc.

Please refer to INPUT.xlsx for the sample input and table format.

Kindly note that I have already read and understand blog about this but still cannot find use cases similar to mine. The Blob: Reporting That Isn’t From a Horror Film - Alteryx Community

Thank you.

[PassION_es]

I already developed a workflow with Blob tool and it produce multiple outputs.  However, the output that I am trying to have should be multiple tab names (instead of files).

[apathetichell]

The blob workflow works off a template files where the files schema (sheet names) do not change.  You can copy the file multiple times - but any new sheets - not in the template file -  will not be formatted. You will need to create a formula with filename|sheet$cellrange to write over the sheet in the file you want.

[PassION_es]

hi @apathetichell , thank you for the response. By the way, can you share with me a sample formula and where to put that? is it after blob input tool?

I have formula to make the filename dynamic but it did'nt work, because although the workflow produced the right sheet names and files, but the file is not formatted, ONly the "sheet1" file is formatted and the rest of the sheets do not have formats.

Here's my sample formula: [File]+"|||"+[GL_AU_Entity]+"$D4:D4"

[GL_AU_Entity] -this is the sheet name (dynamic).

Thank you.

[apathetichell]

Yes. That's what I said. Only the formatted sheet in your template file will be formatted. You must format every sheet you want formatted in your template file.