Data arrangement

[Suvasini]

Hi all, 

Had a small doubt. The input I had given looked like this

Origin	Destination
Delhi	Varanasi
Delhi	Chandigarh
Mumbai	Bengaluru
Mumbai	Chennai
Ahmedabad	Delhi
Ahmedabad	Mumbai

After the workflow and all the tools got executed, my output comes up in ascending order 

Origin	Destination
Ahmedabad	Delhi
Ahmedabad	Mumbai
Delhi	Chandigarh
Delhi	Varanasi
Mumbai	Bengaluru
Mumbai	Chennai

 So basically Ahmedabad came first instead of Delhi which was the first origin in my input, how do I get output in the same order as my input? Would appreciate any help. Thanks!

[JagdeeshN]

Hi @Suvasini ,

An ascending sort using the Sort Tool should get you the output.

Please refer the attached workflow.

Best,

Jagdeesh Narayanan

[Suvasini]

Hi @JagdeeshN 

Thank you for the quick response but I am already getting the output in ascending order. I want to get the output in the same order as my input. There are thousands of rows. But how can I ensure my output comes in the same order as my input order? The input is a random order.

[JagdeeshN · Accepted solution]

@Suvasini 

Thanks for clarifying. In that case a RecordID tool at beginning can provide you with the key for the correct sort order.

Please find attached an example.

Do let me know if this helps.