on 01-04-2017 12:19 PM
Can someone elaborate on the use of count() function in BODS. I was reading a post and someone mentioned 'Map it with the function Count(*)' which was not clear. If i add a new column in output schema and map it as - count (column-name), it asks for doing aggregation in group by clause.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
one example is to if you want to find duplicates and load duplicates into a table then you can use count in bods. but for this you need to apply group by.
It works same like count() in sql.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.