How to paste data in differnect cell ins ame sheet

Hi Folks,

I have two file. One is raw data nand another one is Template. I am trying to copy data from raw file and paste into Template and then save file . I have created differnet outpath with range but while running it throwing error like can not open file as it already used in another program. becasue I am trying to paste data in different cells but same sheet. Is there any way to perform this task ?

Output

Accepted answers

binu_acs

@prpanw Try the Blob tools, the below post might help for your use case

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

All comments

Andrew_T-H

@prpanw, How many output tools do you have?

You might need to put each one in a control container separately and then chain them together so it only does one at a time.

I've found that if I'm trying to output to one sheet, I will get the same error as the file is being used by one of the outputs, causing the other that is trying to complete at the same time to fail.

binu_acs

@prpanw Try the Blob tools, the below post might help for your use case

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

Gaurav_Dhama_

This thread has the same question. Check it out.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Copy-same-data-into-multiple-cells-into-output-file/m-p/1405727#M348657

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703