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 !
Solved! Go to Solution.
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?
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 !