Overwrite cells in formatted template

Dear community,

my wish is to overwrite a cell in my excel template which is also used as my input. Cell E16 should contain a specific ID number (e.g. "111111"). At first, I check if the cell is empty. If yes, I would like to fill in the ID number "111111". I want to overwrite the empty cell in the input template with the ID number which is filled in by using a formula tool. I tried to use the output tool with its "overwrite" function but it didn't work.

I hope that it will be working somehow.

Thank you very much for your help!

Kind regards

rodeo4pple

Output

Accepted answers

grazitti_sapna

@r0deo4pple , Please see this post it might clear out things for you. In case you are overwriting sheet then it will overwrite whole sheet if you have not specified the cell range. In this post in the solution they have provided the range as well to update the data.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-one-excel-sheet-data-to-overwrite-cells-in-other-sheet/td-p/926996

ShankerV

Hi @r0deo4pple

Please find the use case for editing only the cell E16.

Input was:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

All comments

ShankerV

Hi @r0deo4pple

Please use formula tool or Multi row tool to do the overwrite.

Many thanks

Shanker V

grazitti_sapna

@r0deo4pple , It will overwrite the whole sheet and not just the updated cell. You need to pass the complete input data with the updated cell to the target and choose Overwrite to overwrite the same sheet with the new data.

ShankerV

@r0deo4pple

Please use the syntax like,

If IsNull([Field1])
then 11111
else [Field1]
endif

Please find an use case below.

Input was:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

r0deo4pple

@grazitti_sapna Then I understand why it didn't work. Thank you. And could you please tell me more in detail the way you described?

@ShankerV Thank you for your response but I think you misunderstood my question. I want to output "111111" in cell E16 in an excel template (overwrite cell E16), not in Alteryx.

grazitti_sapna

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-one-excel-sheet-data-to-overwrite-cells-in-other-sheet/td-p/926996

r0deo4pple

@grazitti_sapna Thank you very much. It was the field "preserve formatting" which I forgot to click on. 😀

@ShankerV Thank you for your help!

r0deo4pple

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703