To Create Duplicate tab in excel with format and value intact using Alteryx

Question

Hi Team,

I have source excel file where I have two tabs Tab-A and Tab-B.

Tab-A is having formatting such as color of rows based on its values etc as well it holds excel formula in few columns.

Requirement is to create an output that having both Tab-A and Tab-B with following detail:

For Tab-A - As is it is in the source file

For Tab-B - I want to copy Tab-A data into Tab-B where with below needs to be incorporated:

1 -To copy complete format of Tab-A to Tab-B

2- To copy only values from Tab-A to Tab-B

3 - Don't want to copy formula used in Tab-A to Tab-B, rather want only values (mentioned in 2).

Want to perform this activity using Alteryx tool.

Please suggest!!

Thanks

A

Qiu · Answer

@amsrivastava 
As of now, it appears that we have use some sort of VBA to replicate one Tab in the existing Excel file.

Then we can clear the data and use the method from @MeganBowers to output the data from Tab A.
I dont have complete workflow for this now, still try to work on it.

MeganBowers · Answer

Hi @amsrivastava, if you want to preserve your Excel formatting, you can use the blob tools like this blog demonstrates: https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280. It has an example workflow you could modify for your use case :)

Best,

Megan