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.
SOLVED

Grouping columns based on row value

Puru
7 - Meteor

Hi

Looking to connect row 2 Field 1 value based on Field 2 row 1 value and follow same logic for all rows.

So that Field 2 row value is always next row Field 1 value.

Thanks

 

Field 1Field 2
ParisMilan
LondonRome
MilanZurich
BarcelonaLondon
ZurichBarcelona
LondonAmsterdam
AmsterdamRome
8 REPLIES 8
DavidP
17 - Castor
17 - Castor

Do you mean like this?

 

DavidP_0-1585605584994.png

 

Puru
7 - Meteor

Hey

I am looking for result like as follows. Multi row works but it picks up only single cell value. 

 

Field 1Field 2
ParisMilan
MilanZurich
ZurichBarcelona
BarcelonaLondon
LondonAmsterdam
AmsterdamRome

 

ydmuley
12 - Quasar
12 - Quasar

@Puru You can leverage Iterative Macro to solve your problem

 

I have attached the workflow here.

 

Kindly note that the duplicate values might not give you the exact output. Hope this helps or at least gives you an idea.

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Puru
7 - Meteor

Thanks a lot.

 

Not sure if there is any error opening Macro but it shows following:

 

Puru_0-1585663132582.png

 

ydmuley
12 - Quasar
12 - Quasar

My bad! re-attaching - Please check

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Puru
7 - Meteor

Thanks again

This did not open either. Would you want to open the workflow, paste screen shot with notations?

Also should the Macro file be not yxmc?

ydmuley
12 - Quasar
12 - Quasar

Here we go!

 

ydmuley_0-1585666427406.png

 

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Puru
7 - Meteor

Thanks again

I have modified City names and London was repeating causing confusion.

Attaching the new Macro based on one you sent, however the final sequence is not the desired one though the leg shows correct association.

Original   Desired one 
IDField 1Field 2 IDField 1Field 2
1ParisMilan 1ParisMilan
2AmsterdamRome 3MilanZurich
3MilanZurich 5ZurichBarcelona
4BarcelonaAmsterdam 4BarcelonaAmsterdam
5ZurichBarcelona 2AmsterdamRome
6RomeFrankfurt 6RomeFrankfurt
Labels