Free Trial

Alteryx Designer Desktop Discussions

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

Iterative Macro help

WestonProhaska
8 - Asteroid

Hi All, 

I'm struggling on an iterative macro example. 


Essentially, I have data like below:

2014

20152016Start %End %IncrementAdjustment
.4.4.4.4.2.05A

,4

.4.4.4.15.05B

 

1. Is it possible to configure my macro to get me an output similar to something like below? 

-I want to add the previously completed iteration conditions to the ones  that continue onwards after finishing the condition. 

Results of current macro:                                                                                   

2014

20152016Start %End %IncrementAdjustmentScenario
.35.4.4.4.2.05

A

1

,35

.4.4.4.15.05B1

.3

.4.4.4.2.05

A

1

.3

.4.4.4.15.05B1

.25

.4.4.4.2.05

A

1

.25

.4.4.4.15.05B1

.2

.4.4.4.2.05

A

1

.2

.4.4.4.15.05B1

.15

.4.4.4.15.05B1

Results I'm looking for:

2014

20152016Start %End %IncrementAdjustmentScenario
.35.4.4.4.2.05

A

1

,35

.4.4.4.15.05B1

.3

.4.4.4.2.05

A

1

.3

.4.4.4.15.05B1

.25

.4.4.4.2.05

A

1

.25

.4.4.4.15.05B1

.2

.4.4.4.2.05

A

1

.2

.4.4.4.15.05B1

.2

.4.4.4.2.05

A

1

.15

.4.4.4.15.05B1

 

I've also attached the sample package I put together. Thanks in advance!

1 REPLY 1
ArtApa
Alteryx
Alteryx

Hi @WestonProhaska - You don't have to have a Macro for this use case. Attached is a possible solution for you:

 

ArtApa_0-1664602388387.png

 

Labels
Top Solution Authors