Is it possible to create the following output template on Alteryx?

[Yeonsujen]

Hello,

I have been given the "Workbook Output Template.xlsx" file as the required output. Unfortunately, this is not negotiable, and it must look like this specific format and include every cell from this output.

All cells in red need to be pulled from the "Data.xlsx" file. In the output, cells E10, E14, I10, I24, 125 need to be positive.

I'm not sure if I need to create this template from scratch or if there's a way to pull in this template and go from there? I'm still a beginner and have only used simple table outputs. Please let me know if this is possible and if so, how can I approach this?

Many thanks!

[Qiu]

@Yeonsujen 
The Excel output function has an option of preserving the fomatting, but in your case, the update is required for some particular cells.
I think even we can do it, it will be a very brutal one. 

[Yeonsujen]

@Qiu Thanks for your response!

In this case, what would I put down as the range in the output function? Would it be best not to do this? I would love to hear your thoughts on why this would be complicated - just for my own understanding! 

[Qiu]

@Yeonsujen 
Dont trust my opinion hehe.
If your data is not changing in the format, a Vlookup might just the job.

Alteryx is good at the data stream processing, meaning that the whole data is being processed at the same time.

However, this results to be weak at spot data processing, which is your current case.

[Yeonsujen]

@Qiu 
Haha your opinion is still appreciated! I would be curious to see if there are other responses.
You're right, doing this manually through Excel seems a lot quicker in this case. Thanks for your explanation! 😊