07-12-2017 11:28 AM - edited 02-03-2024 11:26 PM
Hi guys
I have gone through lot of forum question related to rank but only 1 looks what I am looking for
https://archive.sap.com/discussions/thread/3608785
I want to ask do I need to create sql function in sql server and then call sql server function in query transform in dataflow..
There is no in-build rank function in BODS.
I tried using gen_row_num_by_group(column name) but it is creating unique row number for each row for group id whereas I want it is should generate same number for group id same result expected in the forum question above mentioned.
regards
User | Count |
---|---|
13 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.