Understanding capabilities - non-database input format

glemieux

Hello, 

I'm new to Alteryx, I watched all the video and played around with it. When the Data Input is in a database format, the capabilities are clear to me. Where I'm confused is if I can use Alteryx when I have let say 2 input file with a known output format but where the input is now a a database format. I have attached 2 sample input and the desire output. Wondering if this is something I can automate with Alteryx.

Thanks

Output_Sample.xlsx

Sample_Input 1.xlsx

Sample_Input 2.xlsx

BS_THE_ANALYST

@glenglen, can you automate this with Alteryx? Absolutely.

If you need to output the data to an Excel file which has a specific template there's various solutions to achieve this! Things like using Blob Tools or even using the Output Data Tool which allows you to write out to specific excel ranges on the file.

If you want to look at examples using the blob tools, this blog is one of my all time favourites: https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280 .. it's even got the workflow attached that you can download and run 😎.