Alteryx Solution Required

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.

Mapping.xlsx

Input.xlsx

Output.xlsx

Common Use Cases

Accepted answers

All comments

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

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703