Overwrite cells in formatted template

[r0deo4pple]

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

[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 · Accepted solution]

@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-overwrit...

[ShankerV · Accepted solution]

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

[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]

-