Alteryx Solution Required

[Arvind_Dhuliya]

I have three files: an input file, an output file, and a mapping file. I need to pull data from the input file and populate the yellow cells in the existing output file according to the mapping file. Could someone help me design an Alteryx workflow to achieve this?

File format will remain fixed.

[Qiu]

@Arvind_Dhuliya 
Check this post, and it should work for your case.

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

[Arvind_Dhuliya]

Issue I am facing is pasting multiple values to specific cells in already existing output file.

[Arvind_Dhuliya]

Thanks for answer, but my requirement is bit more complicated, need to populate data in specific cells, your solution is copy pasting  a table in output data.

[apathetichell]

@Qiu 's response shows you how to make a copy of an excel file for a blob template - you can then edit the cells you need to edit in the new file. There are many posts on how to do this on this forum. search for "blob template."

[Qiu]

@Arvind_Dhuliya 
Just as @apathetichell mentioned, if you have checked the Blog by @NicoleJ , you would see that you can actually output the content to your specific cell.
@apathetichell 
Thank you for the follow-up.

[Arvind_Dhuliya]

Solution provided above  is pasting values in a range “sheet1$E9:G14” , but in my case data is spreading sporadically in different cells and not in any particular range, most of people I talked with say Alteryx can’t do it directly ,I need to write python code for it, or if someone can look at the files which I attached earlier and provide solution, I would be grateful.

[apathetichell]

That is a sample. YOU need to create the dynamic logic to update that.  That is YOUR job. so if it goes to a new sheet name in column [DoYourJob] it would be '|`'+[DoYourJob]+'$'+[YourCellStart]+':'+[YourCellEnd]+'`' - and note if you are putting one cell - drop the headers and make sure you are sending in one value.