Count for string columns

CloverDX Platform
1

Hi,

In the “Aggregate” component, I am trying to do a count() for a string column. But when I run the graph, its giving an error like “I can use count() function only with integer columns”.

Is it possible to use the count() function for string columns.

Thanks & Regards,
Akhil

2

Hi Akhil,

can you please sent me exact text of exception? I can reproduce 2 similar issues:

1] “Function count(): output field field1 has invalid type, must be numeric” - result of count really must be stored into numeric field (you can use Reformat converting 2 metadata types later)
2] “Function count() doesn’t accept any field as a parameter” - when mapping field is used

3

Hi Jaroslav,

I am getting the first error as you mentioned. Is there is anyway I can use the count for string columns.

Thanks & Regards,
Akhil

4

Hi Akhil,

yes, that is simple. For Aggregate output use metadata with numeric type and then change them to metadata with string type via Reformat. Please see attached sample.