count for string columns

akhil

• December 31, 2012 00:00

• Answered

Follow

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

• 

  admin

  • January 02, 2013 09:21

  0

  Comment actions Permalink

  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
• 

  akhil

  • January 07, 2013 23:39

  0

  Comment actions Permalink

  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
• 

  admin

  • January 08, 2013 09:04

  0

  Comment actions Permalink

  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.

  • test.grf

Please sign in to leave a comment.