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

Alteryx designer Discussions

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

The latest release includes several enhancements designed to improve your Community experience!

Learn More

Compare and Match align fields data

Highlighted
Asteroid

Hello All,

how to align the field1 data based on field2 matching data in alteryx. please find the expecting output.

Kindly Suggest me.

 

RAW Data:

Field1Field2
[Null]I
LC
IG
CK
GL

 

 

Result

Field1Field2Matching Level
[Null]I1
IG2
GL3
LC4
CK5


Thanks in Advance
NR

Bolide

Hi Niranjan123,

 

What logic are you currently using to determine your Matching Level values, and thus the order of your data rows in the result?  I can't see an obvious method to get from your first table to the second from your initial explanation.  If I can understand your current process, I expect that I would be able to reproduce this in Alteryx. 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Niranjan123 I managed to produced the output you described using an Iterative macro. I've attached my workflow with the macro as well. Let me know what you think or if I need to explain in more detail the solution I produced.Match_Align_190919.PNG

Labels