Customer Portal

count for string columns

Comments 3

  • Avatar
    admin
    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
  • Avatar
    akhil
    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
  • Avatar
    admin
    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.

Please sign in to leave a comment.