Coupa Llamasoft Download Model Tables v2024

[#1]

This is a new version of the Coupa Modeler Table Download macro.

It is built to easily bring in the data from  llama.ai into  your workflow.

New features:

• No need to use a text tool for  the input: there are two text fields where you paste your API key and Model ID ( Model ID is a long string at the end of the url on llama.ai where your model is stored, and you can generate an API key by clicking the user icon and selecting “generate API key”. If you have an API key already, retrieve it. If you re-generate a new key, the old one will become inactive).
• No need to know the back-end name of your tables. First of all, select “yes” in the first drop-down to generate a list of all non-empty tables in your model and their number of records. After you run the macro, in the output #0 you can select the table names that you need (some common ones include OptimizationOutputCustomerFlows, OptimizationOutputsProductions, OptimizationOutputNetworkPathsSummary, Scenarios, Products, etc), and use the names in the next dropdowns. You can select up to 5 tables. 
•  This version is about 5 times faster than the previous one: while the exact speed depends on your network connection, I am able to fetch about 1 M rows in 2 minutes.
• The macro will fetch the name of the model as part of the #1 output. 
• Empty columns will not be retrieved.

Download the attached package file, save it in the folder that is mapped to your macros (options - user settings - macros), then you can right-click on any Alteryx's workflow canvas, navigate to "macros" and insert the Coupa Llamasoft Download Model macro.