2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you uninstall it, and then install the latest 2022.1.1.30961 version.

Alteryx Designer Discussions

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

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

BAvitia88
7 - Meteor

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
13 - Pulsar

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
7 - Meteor

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
7 - Meteor

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

Labels