Hi all, Had a small doubt. The input I had given looked like this OriginDestinationDelhiVaranasiDelhiChandigarhMumbaiBengaluruMumbaiChennaiAhmedabadDelhiAhmedabadMumbai After the workflow and all the tools got executed, my output comes up in ascending order OriginDestinationAhmedabadDelhiAhmedabadMumbaiDelhiChandigarhDelhiVaranasiMumbaiBengaluruMumbaiChennai 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!

Data arrangement

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!

Output

Accepted answers

JagdeeshN

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

sample.yxmd

All comments

JagdeeshN

Hi @Suvasini ,

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

Please refer the attached workflow.

Best,

Jagdeesh Narayanan

sample.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703