Difficult Task Here

Hi:

I am thinking about an interesting workflow.

In Excel Sheet 1, I can use an Alteryx output. The formulas in Sheet 2 will automatically update based on the numbers in Sheet 1.

I want to finish the above process in Alteryx not in Excel. So basically Alteryx will output a file with 2 sheets. Sheet 1 will still be the same and Sheet 2 will contain excel formulas calculating the results based on the numbers from Sheet 1.

Do you think this is possbile in Alteryx? Otherwise, I will just do it partially in Excel.

Regards,

Best Practices

Accepted answers

jrgo

@Ibx,

The option "Overwrite File (Remove)" will completely replace the file. In reference to your original question though, this option will impact ALL sheets.

All comments

jrgo

@Ibx,

I don't see why it wouldn't. You'll need to make sure that you select the correct "Output Option" when configuring your Output tool. "Overwrite Sheet (Drop)" will only replace the sheet and not touch anything else other sheets.

Ibx

This is amazing.

Is there anyway I can let Alteryx to output the entire file? So I don't have to save and override the existing file?

I may need to output multiple projects details so I am just wondering if I have to override and save them one by one.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703