Search for a specific Row

[Maha-Massoudi]

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

[pedrodrfaria]

Hi @Maha-Massoudi 

You would be looking at the multi row:

Before

After

Pedro.

[Maha-Massoudi]

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

[SeanAdams]

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...