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"
COMPANY | Item | Acc | SUBAcc | $$ |
000005 | 00001 | 002500 | 5,356,356.00 | |
000005 | 00001 | 002500 | 343,425.00 | |
000005 | 00001 | 002500 | 857,585.00 | |
000005 | 00001 | 002500 | 163,849.00 | |
000005 | 00001 | 002500 | 94,746,456.00 |
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!
@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.