Identical items on one column to another column, place it one under the other

Question

Hi,

I have a query which I am not sure if this can be done on Alteryx

I have two columns

ID 1ID2TRE002227X1TRE002229AD2TRE002231RR24TRE002235TEW333XWQ1TRE002224DD45TRE002229DDR456TRE002230TDDTRE002231

The result I expect is the following:

ID 1ID2TRE002227X1TRE002229AD2DD45TRE002229DDR456TRE002230TRE002231RR24TDDTRE002231TRE002235TEW333

Kind Regards,

Dan

ArtApa · Answer

Hi @DanielCarro - Here is a possible solution. I don't understand why the row DDR456 in your expected outcome moved up though.

OneUnderTheOtherAA.yxmd

DanielCarro · Answer

Hi Frederik,

The objective is that the number in col ID1 and the same number in ID2 should be directly underneath. As per the example

TRE002229AD2DD45TRE002229

FrederikE · Answer

Hey @DanielCarro,

I would use smth. like a transpose and then a unique Tool after it. See the attached WF (Solution is not exactly as yours as I don't understand it completely, but this should help you do it).

New Workflow1.yxmd