How can I move record from bottom to all the way up

[Kinetic_analytics]

Hello:

Good afternoon. How can I move a record up? I want row number 12 to be Row number 1.

Appreciate your help.

[IraWatt · Accepted solution]

Hey @Kinetic_analytics,

You can use the record select tool to select the 12th record then union it above another record select tool which selects everything else:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Kinetic_analytics]

Thank you! What a joy! brilliant you. Appreciate your efforts. :)

[Kinetic_analytics]

question for you: How about the position is not always exact. Regardless of the position, "L" should be the number 1 record in the table. 

[IraWatt]

Thanks @Kinetic_analytics 😄! You just need a way of identifying which row needs to go on top. For instance, you could use a filter tool to Split the data on the L row then place it on top using the union tool like before:

Interestingly this approach only work with the AMP engine on for me.

.