on 11-27-2018 6:16 PM
Hi everyone!
I would like to ask you about a problem im facing with a SAP HANA Calculation view....
I create a Calculated column for a Flag (it contains the values 'S' and 'N').
Then i use this flag in the filter expression in a projection. I want to pass only the data with FLAG_INCO = 'S'. But i get 771 rows when i should get 4835.
If i make a data preview i can see that there are 4835 rows with the FLAG_INCO = 'S'
The fact is that if i apply the FLAG_INCO as a filter, i get only 771 rows...
I have already checked that there are not duplicates and so...
I tried also to create a second calculated column (FLAG_INCO2) with the value of FLAG_INCO and use it in the filter expression...but the result is the same.
Any ideas?
I use Eclipse, version Luna Service Release 2 (4.4.2)
Thank you!
Best regards!
Hi,
May be it is about distinct (not duplicate) records count
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.