topic Re: Ranking in App Development

Ranking

KharansuR93 — Wed, 06 Oct 2021 09:52:26 GMT

Hi, I have a situation where, I need to select the 1st row in a column wherever the value changes and for the same value there are two other values in another column and those two rows should also be reflected. For example

A B

1A Victory

1B Victory

1B Success

1C Success

1C Victory

so here I should only get the rows where Victory or Success or ' ' come 1st with different values in column A

Thanks,

Kharansu

Re: Ranking

abhijitnalekar — Wed, 06 Oct 2021 09:59:57 GMT

Hi @KharansuR93 ,

Can you please describe the data and output in detail?

The tabular format will help to understand the requirement easily

Re: Ranking

KharansuR93 — Wed, 06 Oct 2021 10:10:08 GMT

Hi abhijitnalekar,

Let's take the below table -

and I should get only sl no. 1,2,4,6,7,11,12,15,16 rows as my output. Now I don't have a Sl no. column, can we do it with index or rowno() or anything else?