community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Macro that cycles through Names

Meteor

Hi there,

 

I am trying to create a macro that will cycle through names in a list. I want to embed this macro within my workflow to create one output file for every name/id in the list. 

 

The goal output will contain a file unique and specific to the selected name in the list.

 

Attached is the progress I've made thus far. I am unsure how to create this to iterate through the other names until all names have cycled through. Any advice is greatly appreciated. Additionally if you see an issue with my end goal of creating unique files based on each name by using an iterative macro at the start of a workflow please let me know! 

 

Thanks!!

Alteryx Partner

 

 

This approach may meet your needs.

 

2018-02-06_00009.png

 

 

Meteor

Thanks for the suggestion. This approach would work but I also need data included in the output that includes the entire team (Adam, Ben, Charles, Dave, Ed). Any thoughts on how to accomplish this?

Alteryx Partner

@ccaprio

 

If you have more columns (fields) of data associated with each name than that data will also be output in the same manner.  Example attached.

 

Is this what you meant?   If that's not it then please provide an example.

 

2018-02-11_00020.png

Alteryx Partner

@ccaprio

 

Here is a second version that will give you all 5 records in each report.

 

2018-02-11_00023.png

Meteor

Thanks for all the feedback! 

 

It does not appear that either of these options will allow me to include team data in the final output. I've included a JSON example of what I am trying to create below. I need the AE array to create a unique file for every team member (one would be created for Nick Tan, Gretta James, etc) but still need the entire team included in other arrays for comparison purposes. 

 

 

{

"Team_Summary": [
{
"Count": "5",
"Sum_Amount": "8500000",
"Name": "Ryan Law"
},

{
"Count": "81",
"Sum_Amount": "58870000",
"Name": "Gretta James"
},

{
"Count": "60",
"Sum_Amount": "74400000",
"Name": "Nick Tan"
},
{
"Count": "64",
"Sum_Amount": "51094540",
"Name": "Carrol Cassil"
},
{
"Count": "1",
"Sum_Amount": "1000000",
"Name": "Ryan Mann"
}
],
"AE": [
{
"StageCreate": "2016-11-30 16:42:16",
"AE": "Nick Tan",
"Name": "INBI",
"Amount": "4000"
},
{
"StageCreate": "2016-12-19 20:45:41",
"AE": "Nick Tan",
"Name": "INBI",
"Amount": "7500",

}] }

 

 

Thoughts?

 

Thanks! 

 

Cari

Meteor

 I need the AE array to create a unique file for every team member (one would be created for Nick Tan, Gretta James, etc) but still need the entire team included in other arrays for comparison purposes. 

 

 

{

"Team_Summary": [
{
"Count": "5",
"Sum_Amount": "8500000",
"Name": "Ryan Law"
},

{
"Count": "81",
"Sum_Amount": "58870000",
"Name": "Gretta James"
},

{
"Count": "60",
"Sum_Amount": "74400000",
"Name": "Nick Tan"
},
{
"Count": "64",
"Sum_Amount": "51094540",
"Name": "Carrol Cassil"
},
{
"Count": "1",
"Sum_Amount": "1000000",
"Name": "Ryan Mann"
}
],
"AE": [
{
"StageCreate": "2016-11-30 16:42:16",
"AE": "Nick Tan",
"Name": "INBI",
"Amount": "4000"
},
{
"StageCreate": "2016-12-19 20:45:41",
"AE": "Nick Tan",
"Name": "INBI",
"Amount": "7500",

}] }

 

 

Thoughts?

 

Thanks! 

 

Cari

Labels