Copy same data into multiple cells into output file

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.

Developer

Developer Tools

Accepted answers

Gaurav_Dhama_

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.

DuplicateDataOutput.yxmd

All comments

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/970280

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_

Ok here you go.

Hope that helps.

DuplicateDataOutput.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703