on 06-25-2016 12:53 PM
I am new to HANA Modeling and I am not sure how to add a Rank column.
Here is my data
Employee Date Seq Value
E001 6/21/2016 01
E001 6/21/2016 02
E001 6/22/2016 02
The data will be sorted by Employee, Date, Seq Value
I want to add a Rank column for each unique Employee + Date combination
Employee Date Seq Value Rank
E001 6/21/2016 01 1
E001 6/21/2016 02 2
E001 6/22/2016 02 1
Can I do in a Calculation View or do I need to write an SQL Script?
Thanks.
Sandy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sandy,
you can do this in a graphical Calculation View.
Check the online help: Create Rank Nodes - SAP HANA Modeling Guide for SAP HANA Web Workbench - SAP Library.
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.