Move Field to the End of Column

Question

Hi everyone,

I have a following table:

Name            Age         City

John              15           London

Katy               17           Birmingham

George           14          Paris

I need to move John's whole row to the bottom, but the actual dataset I have is of course much more complicated and extensive. How could I do this?

Thanks!

ShankerV · Answer

Hi @insomned

Step 1: Input

Step 2:

IF [Name]="John"
THEN 1
ELSE Null()
ENDIF

Step 3:

Step 4:

Many thanks

Shanker V

ShankerV · Answer

Hi @insomned

Please find the expected output.

Many thanks

Shanker V

ShankerV · Answer

Hi @insomned

Try to use formula tool to Mark some indicator if John found.

Then Split it from the dataset.

Use Union tool to join at the end.

Many thanks

Shanker V