Migrate Data from Input Tab to Output Tab

Question

Hello,

can we migrate/transfer data from input tab to output tab without any format change. i need to move a table with all highlighted color, font style/size into output file. for example this following data is from input file tab name "April" and now how can i move this tab including same format(color, font size, etc...) into my output file with same tab name "April". Appreciate if you can show me the guide line with a demo workflow. this is my third time to open this topic because my last two requests with same topic are still open (no particular solution have been provided).

also if this request is not possible in Alteryx then confirm so i can update my team/business.

from Tab "April"

COMPANYItemAccSUBAcc $$ 00000500001002500                  5,356,356.0000000500001002500                      343,425.0000000500001002500                      857,585.0000000500001002500                      163,849.0000000500001002500                94,746,456.00

jrlindem · Accepted Answer

Recommend reading up on the BLOB tool.  I think this might get you where you need to be.

This discussion thread (Tab transfer from input to output file - Alteryx Community) is similar and the response from @EKasminsky with the following link may be of use: Alteryx Tool Tip: Don’t Fear the Blob - Lovelytics

Cheers!

BS_THE_ANALYST · Accepted Answer

@kauser there's a great article on this: https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

I think this relies on inserting data into a template but it'll preserve formatting. There's potentially other routes as well which could leverage the Run Command with a VBA-type script.