Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need a Batch Macro to use Dynamic input to run HANA input

BAvitia88
8 - Asteroid

Greetings, 

 

There is a HANA model that provides the Bill of Materials, takes one material and provides all the sub assemblies and raw material needed. 

 

There is a table that is generated with around 3k materials that I need to batch pass through the HANA model, where each material represents the input parameter for the model. 

 

Using the action I can replace the field and update by adding a record count and sampling the first. 

 

However not sure the order of the workflow so that it processes all the records. 

 

Something like this:

Row 1: Cake A

Row 2: Cake B

Row 3: Cake C

 

Row 1 Cake A is feed to the HANA model as the IP that produces this list

  • 1 box Vanilla Powder cake mix
  • 2 Eggs
  • 1 Tbsp. of Apple sauce
  • 1 Tbsp. of olive oil

Once row 1 is processed we proceed to row 2

Row 2: Cake B is feed to the HANA as the IP model that produces this list

  • 1 box gluten free Vanilla Powder cake mix
  • 2 Eggs
  • 1 Tbsp. of Apple sauce
  • 1 Tbsp. of olive oil

Row 3: Cake C is feed to the HANA model as the IP that produces this list

  • 1 box Vanilla Powder cake mix
  • 2 Eggs
  • 2 Tbsp. of olive oil

 

Result desired report would be a listing:

 

Cake A

  • 1 box Vanilla Powder cake mix
  • 2 Eggs
  • 2 Tbsp. of olive oil

Cake B

  • 1 box gluten free Vanilla Powder cake mix
  • 2 Eggs
  • 1 Tbsp. of Apple sauce
  • 1 Tbsp. of olive oil

Cake C

  • 1 box Vanilla Powder cake mix
  • 2 Eggs
  • 2 Tbsp. of olive oil
3 REPLIES 3
ChrisTX
15 - Aurora

Have you worked with batch macros before?  Can you create a sample workflow, and describe specific challenges?

 

If you have a unique list of a single input parameter like

like:

Row 1: Cake A

Row 2: Cake B

Row 3: Cake C

 

You can pass the single data stream into both input anchors of a batch macro, and use the Control GroupBy Field.

ChrisTX_0-1656014779352.png

 

If you're new to batch macros, try

  Learn > Academy > Learning Paths and

  Learn > Academy > Videos

 

Chris

 

BAvitia88
8 - Asteroid

Thank you

 

Forgot to mention that some of the components can be builds them selves, so we would need to identify and get the bom for that lower level as well. 

 

For example 

Row 2: Cake B

  • We Make the White Cake gluten free
    • We would need the ingredients for that flour mix

Kind of an iterative macro until all the items are buys

BAvitia88
8 - Asteroid

Thank for the info on the macros. It resulted I needed the dynamic input and not a macro. over complicated myself. 

Labels