Search for a specific Row

Question

Hi everyone,

I need your help.

I need to organize my dataset as bellow:

the trip next should be the follow record of the actual trip:

[Row+1: Trip No] = [TripNext], and to update all the dataset as well.

How can i do it?

Best regards

in attached the actual organisation of the dataset

SeanAdams · Answer

Hey @Maha-Massoudi ,

The Multi-row solution that @pedrodrfaria recommended will only impact the columns that you choose to change - the rest of your data stays the same.

Give it a try - there's also a great article here by @Kenda that teaches more about the Multi-Row tool: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p/86603

Maha-Massoudi · Answer

thank you @pedrodrfaria  for your response.

In fact i need to update all the dataset with the reorganisation of the rows.

working onely on the trip number will update the tripnumber field but not all the table.

Do you have any suggestions?

Thank you

pedrodrfaria · Answer

Hi @Maha-Massoudi

You would be looking at the multi row:

Before

After

Pedro.

Search for a specific Row.yxmd