We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Migrate Data from Input Tab to Output Tab

kauser
8 - Asteroid

 

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.00
00000500001002500                      343,425.00
00000500001002500                      857,585.00
00000500001002500                      163,849.00
00000500001002500                94,746,456.00
2 REPLIES 2
jrlindem
11 - Bolide

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
15 - Aurora
15 - Aurora

@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/... 

 

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. 

 

All the best,
BS

LinkedIN

Bulien
Labels
Top Solution Authors