Issue Rendering Formatting in an Output Workbook

Question

Hi there,

Hope everyone is doing well.

I am creating this post as I am having an issue with a simple workflow I am trying to put together. I've seen a couple other posts on this topic but neither really addressed the original question that was asked, nor did they apply to my specific flow.

I have attached the workbooks "Fruits", "Veggies", "Formatter", and "Expected Output".

The first 3 workbooks are used in the flow I have created, while the "Expected Output" workbook represents what I would like the final outcome to look like.

Essentially I want to keep the formatting that is rendered in the first step of the block until done tool, but add that formatted output to a final workbook called "Current Output".

I have attached the flow that I have used to reach this point. The result that I currently am receiving after running the flow appends the combined fruits and veggies spreadsheet to the output workbook as desired, however it only applies the formatting to the "Formatter" sheet, and not in our appended output. Instead, in our appended final output ("Current Output"), it creates a column called "Table" that has many HTML div class tags underneath and does not apply the formatting (not sure why it is doing this, maybe styling tags that aren't being applied for some reason?). I have attached a screenshot of this issue as well in a reply to my own post as it only allows 5 attachments at a time.

What's the simplest way to reach my "Expected Output" using this flow method? Would greatly appreciate your help.

Thank you,

Shaan

Fruits.xlsx

Veggies.xlsx

Formatter.xlsx

Expected Output.xlsx

question_flow.yxmd

Amol_Telore · Answer

Hey @shaantrika

I have created a a workflow which may solve your concern. I have followed below steps.

* I have created Formatted output using new data.
* Transferring data from existing file (Current Output File in your scenario) to formatted file.
* Transferring data from formatted file(New data with formatting + Old data W/o formatting) to final file using blob input as it retains the formatting.

Hope this solves your concerns. Attached is the workflow.

Edit 1: Attached workflow. It was missed to attach last time.

Regards,

Amol Telore

question_flow.yxzp

apathetichell · Answer

One approach would be - block until done - create two sheets in Render - 1) your formatted output. 2) a placeholder sheet for your raw/unformatted data. 2) from a different part of your block until done output data over your placeholder sheet.

kathleenmonks · Answer

Ah @shaantrika , I see now. Thank you for the clarifications. The render tool will always overwrite the existing excel file. In order to do what you mentioned above, you can create the formatting you want in the destination sheet (do this inside of Excel and not Alteryx so that the whole workbook isn't overwritten every time) and then in the output tool, check the box for "Preserve formatting on overwrite." The output option will also have to be set to "Overwrite Sheet or Range."