Use of count() function in SAP BODS

[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.

[former_member198401]

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

[former_member208402]

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.