Skip to Content
0

Use of count() function in SAP BODS

Jan 04, 2017 at 12:19 PM

632

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ravi kiran Pagidi Jan 05, 2017 at 11:34 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Jan 05, 2017 at 01:24 PM
0

Count() will count the number of values in a group.

If you want to count the number of employees by Department the you can use this function in the Column Mapping as count(DEPT_NAME)

Group by on DEPTNO and DNAME

Regards

Arun Sasi


3aikh.png (3.1 kB)
hvs9r.png (2.7 kB)
Share
10 |10000 characters needed characters left characters exceeded