Skip to Content
avatar image
Former Member

Use of count() function in SAP BODS

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2017 at 11:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 01:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded