Compare and Match align fields data

Question

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]ILCIGCKGL

Result

Field1Field2Matching Level[Null]I1IG2GL3LC4CK5

Thanks in Advance
NR

geraldo · Accepted Answer

Hi

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

Follows attached workflow

[]

benakesh · Accepted Answer

Hi @PeterA1 ,

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

PeterA1 · Accepted Answer

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: