0

How To? Return each value from Map instead of array

When using map, is it possible to return each element of the function instead of the array?
Or is it possible to combine the returned arrays?

 

Thanks!

4 comments

  • 1
    Avatar
    Meggan King

    Hi -

    You can combine the arrays returned by building up your list with JOIN and ARRAY.

    Using something like:

    ARRAY( JOIN( MAP( ARRAY(), var, JOIN( formula))) )

     

    We are releasing a new formula which will do this all at once for users. It should be released mid-July. 

     

    Thanks,

    Meggan

  • 0
    Avatar
    Senduren Sivakumar

    Thanks Meggan, that worked - 
    After doing this, is there a way to convert the returned values from strings to numbers? 

  • 1
    Avatar
    Meggan King

    Hi -

    Yes :)

    You can wrap NUMBERFORMAT() around it. Hope that helps!

    https://support.klipfolio.com/hc/en-us/articles/215547838-NUMBERFORMAT-function- 

    Thanks,

    Meggan

  • 0
    Avatar
    Senduren Sivakumar

    Got it!

    Thanks for your help Meggan - new to the platform and still learning the ropes.

     

    Sen

Please sign in to leave a comment.