multiple functions on a column?

Answered

Follow

Sharon

• July 02, 2019 21:29

Hi, I'm new to datameer.  Is there a way to execute multiple functions on a column, or is it one function per column?

For example:

Two columns:

FORMATDATE(#parsedata!reporting_month_date;"MMM yyyy")
CONCAT(#parsedata!reporting_month_date_string;" - Sales")

Can this instead be written as something like this?

CONCAT((FORMATDATE(#parsedata!reporting_month_date;"MMM yyyy");" - Sales")

0

• Official comment

  

  Brian Junio

  • July 02, 2019 21:47

  Hello!

  Yes, it is possible to nest functions just as you have described.  The order of operations will be from inside to out. 

  In your above example, the FORMATDATE() function would format the 'reporting_month_date' and would then CONCAT() ' - Sales'.  Do keep in mind column type casting as it may come into play when attempting to append a STRING to a DATE type.  

  For additional information, please review our documentation pertaining to Datameer Functions:

  https://documentation.datameer.com/documentation/display/DAS70/Datameer+Functions

   

  Cheers,

  Brian

   

  Comment actions Permalink
• 

  Sharon

  • July 02, 2019 21:57

  Thank you, Brian!  I asked because when I ran my nested version, it returned blanks with no error.  I'm not sure why.  Thank you for the confirmation!

  0

  Comment actions Permalink

Please sign in to leave a comment.