Copy same data into multiple cells into output file

[kauser]

Hello, 

Is there any way to copy same data into multiple cells to output file. Like for example, i need to copy Cell A50 from input file to output file into multiple cells (A320, B250, C500....) 

Input data 

A50

500

Expected Output 

A320	B250	C500	G100
500	500	500	500

Currently i am using individual output file with control container for each one of these cell. 

[Yoshiro_Fujimori]

@kauser ,

If you are dealing with Excel file and want to paste date to specific cells by Alteryx,

this Blog page by @NicoleJ might help.

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...

Good luck!

Yoshi

[Gaurav_Dhama_]

I have one idea, i can validate it as well once i get back to my laptop, meanwhile try it out if you can.
If you want to update same value in multiple cells in excel, duplicate the value that many times, say 4 times, add the location in which cell they must go to. 

Then using formula tool, append the rest of the path to this cell reference. Now in your output tool, use this new path as output destination. If done right it should correctly update all the locations with one single tool.

[Gaurav_Dhama_ · Accepted solution]

Ok here you go.

It worked as expected. In the attached workflow you will find two output tools, reason being that the output file does not exists, so i had to use one output tool with configuration "Create New Sheet" and the other one with "Overwrite Range". Create New Sheet configuration is only outputting the first record; remaining records are being written by the second output data tool. If you have a file that already exists, you can make use of just the second output tool.

Hope that helps.