Transfer cell colors from old output into new output

[AlYap]

Hi,

I am trying to transfer cell colors from an old Alteryx output to a new output without having to manually transfer them. Is there a way within Alteryx to do that? The colors are to help categorize and group items visually.

As shown in example below, it would be great if the colors on the left table transfer over to the right table as new output when the prices are updated. I have a use case for example below but with 20+ columns and 15,000+ rows. Any help welcome!

Example below:

[atcodedog05]

Hi @AlYap 

You can give a look into Output tool preserve tool formatting.

[AlYap]

Any chance this can be addressed through the Reporting tool? I am not using the "Output Data" tool though.

[SeanAdams]

Hey @AlYap - I don't believe that there is any way to include the format of the cell as part of the input tool.    if you wanted to pass through the format for the data using something like the Render tool, you'd need to know the original format, and unless you read the underlying XML for the XLSX file (or read it using Python), I don't think there is any way using a standard input tool to read in the format of cells.