Output data based on multiple entities into diff files which have same template format

Question

Hey,

I want to update certain cells in sheet A which eventually effect other sheets B, C, D and soon. My aim is to just update couple of columns in Sheet A, which I was able to do it for one company code but the challenging thing it's done for one of my company codes, I do have 30 more company codes which required same formatted output in 30 different files. Any suggestion?

Option that I have is to duplicate 30 excel templates manually and divide the results into company codes in the design and connect the result to 30 different output tools to achieve the result which is not efficient way. And also in future the company codes might increase always creating template manually creating an output tool makes tougher.

Any direction/suggestion is greatly appreciated.  Thanks in advance!

Shravz

ShravaniChanda · Answer

Hi  16 - Nebula can you see below example, that is what my exact requirement

ShravaniChanda · Answer

Hey Phill,

Thanks for looking into this, is it possible for to look up the values from data table to template file because in your example country is used to split the files, and copies each country's data into respective files and my requirement is slightly different, Let say I want to split the files based on company codes, each company codes will have few tax codes and then template also has tax codes and cells next to that needs to be updated called tax amounts and VAT without any change in template.(All headers and colors should remain the same)

Below is the snip of the template, green color are the only ones to be updated remaining headers and all the color format should not change. this is for company AAA

there are 30 plus other companies and all the codes for each company should follow and get formatted this way. any suggestion

Maskell_Rascal · Answer

Hi @ShravaniChanda

This is possible in Alteryx using the Run Command tool. Here is a similar post where I outlined how to setup and execute this method.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outputting-multiple-excel-files-using-different-cuts-of-raw-data/m-p/596335#M132786

If this solves your issue please mark answer as correct, if not let me know!

Thanks!

Phil