Desired Formatted Output Required

Hi Everyone,

Formatted output required, i have a sample input file and i want descending output(Col3,Col4) which i shown in Output1, but the Col1,Col2 should be in the same order. Output2 is also required, Find below screenshot, also sharing sample data file.

Can anyone help ? Immediate help will be highly appreciated, Thanks in advance !

Alteryx_2107.xlsx

Output

Accepted answers

binu_acs

@Inactive User Another way of doing this

Ordering_21_07.yxmd

All comments

SPetrie

I understand the numerical ordering of Col4 in the output, but the ordering of Col3 and Col2 dont seem to follow any pattern I can see.

Is the order of Col3 and Col2 important or is it flexible?

Would this type of order work?

Same for output2, how strict is the order of the output?

Would this output work or is it no good because the original Col2 items are alphabetical order instead of original order?

unknown

Hi @SPetrie,

Thanks for your revert, i think this will work for me and also highest value should be on top for a particular value in col1 for e.g; for A EA,EA1,1000 | CS,CS2 850 |CS,CS1 400. FIRST,SECOND,THIRD HIGHEST and so on. I have to perform this for top 5 value for each value in col2. Can you share workflow ? Thanks !

SPetrie

This is the workflow I have so far. Its not doing quite what you asked yet, but its a start.

Let me know if this works for you to build off of or if we need to add more to get it ordered the way you want.

example flow.yxzp

binu_acs

@Inactive User Another way of doing this

Ordering_21_07.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703