Update an excel based on order details and generate one sheet for every order

Question

Hi All, I have a particular business scenario described below

1. An excel empty template is provided - as attached Template_community.xlsx

2. A list of orders are provided - PO_details_Example.xlsx

3. From the above two using alteryx need an output like Template_community_output.xlsx, with appropriate fields populated from PO_Details_Example.xlsx

4. The Template_community_output.xlsx should produce as many number of sheets as there are orders, in this example it has two orders and thereby two sheets (with appropriate order details from PO_details_Example.xlsx populated in this)

any pointers would help!

PO_Details_Example.xlsx

Template_community.xlsx

Template_community_Output.xlsx

ealunkal · Answer

Thanks Qiu, I would try your approach, however I need to make the template myself in Alteryx, instead am looking for an approach to see if I am able to use my own excel template and update the order data into the template exactly as given in Template_community_output.xlsx

Qiu · Answer

@ealunkal 
Alteryx is good at the data processing data stream, not really good at the particular cell processing.

One alternative is that we use the tool "Report Text", but it will not exactly look like what you are asking.

Can you take a look the output?

0310-ealunkal.yxmd