Compare and Match align fields data

[Niranjan123]

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:

Field1	Field2
[Null]	I
L	C
I	G
C	K
G	L

Result

Field1	Field2	Matching Level
[Null]	I	1
I	G	2
G	L	3
L	C	4
C	K	5

Thanks in Advance
NR

[PeterA1]

@Niranjan123 

This can be done using an iterative macro. 

I have attached a workflow package containing a macro I built which will give leveling information based on the input format you provided.

Essentially we needed to create something that loops through the data row by row and matches the Field 2 of the Row -1 with the Field 1 of the current row. 

Below is a screenshot of the internals of my macro. 

[geraldo · Accepted solution]

Hi

A suggestion without using macro is based on this example that you passed

Follows attached workflow

[]

[benakesh · Accepted solution]

Hi @PeterA1 ,

Can you attach file again  .  I can't  find  macro in yxzp .  

[PeterA1 · Accepted solution]

Hi @benakesh 

Is the macro appearing as a question mark box?

I have attached the  macro separately now so this should work. Let me know if not. 

Also, if you map your macro folder they can appear in your tool palette.

There will be a tool category called macros that will contain all .yxmc macro files you save to that file location.

Shown here in User Settings:

[benakesh]

HI @PeterA1 ,

Your macro helped me  resolve my error.

Thanks!

[benakesh]

Hi @PeterA1 ,

Your macro helped me  resolve my error.

Thanks!