Multi- row Formula - alphabetical order

Hello All,

I have a question regarding the Multi-row Formula tool.

Before the Multi-row Formula, the data are in the required order but when I use the Multi-row Formula tool, the tool order them into alphabetical order.

Can you please help me how could I get back the required order after using the Multi-row Formula tool?

Thanks you in advance!

Preparation

Accepted answers

Felipe_Ribeir0

Hi @bakaidora

Ok, looking at your config, i think that you can adapt the attached workflow to reorder it using tile tool before + order by after the multi row.

Multi- row Formula - alphabetical order.yxmd

All comments

Felipe_Ribeir0

Hi @bakaidora

Could you share your workflow, or at least the print of it and the print of the configuration of the Multi-row formula tool? The Multi-row Formula does not change the order of the rows with the default configuration, i would like to see why this is happening for you.

But if this is happening, i would try to find a way to use the record Id tool before and order by the record Id after the Multi-row.

Felipe_Ribeir0

Are you using the group by option of the multi row tool, right? It is really necessary to use it in your case? If not, just uncheck it.

Solved: Re: Multi-row formula changes sorting - Alteryx Community

bakaidora

@Felipe_Ribeir0

Yes I need to use the group by function:

Felipe_Ribeir0

Hi @bakaidora

Ok, looking at your config, i think that you can adapt the attached workflow to reorder it using tile tool before + order by after the multi row.

Multi- row Formula - alphabetical order.yxmd

bakaidora

@Felipe_Ribeir0thanks, this was the solution, just one hint, I needed to activate this box, as well.

karenewilkins

The Tile tool was the solution for a problem I was having with a multi-row formula. I didn't even need the multi-row tool. Thank you!

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335