Tab transfer from input to output file

Question

Hello,

how can i move few tabs from input file without any changes into output file. simply its just copy and paste without any changes. also i want to make sure when i transfer few tabs from input file into output all format (highlighted color, font size/style, table format) will remain same into output file. also note tabs name will be consistent.

thank you

dreldrel · Answer

If this is still not fixed, check this article for more info: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Keep-Formatting-in-Excel-Output/td-p/713204

kauser · Answer

appreciate if you can provide a workflow. my existing workflow is complicated and have control container.

EKasminsky · Answer

I mean you would just use multiple output tools and output to whatever the name of the file is with the sheet name you want. You can preserve or move the formatting using blob tools.

https://lovelytics.com/alteryx-tool-tip-dont-fear-the-blob/

You likely would want to select a large range of cells on the output file and use "Preserve Formatting on Overwrite" so the formatting stays when you write to the tabs in the output file.