Forum Discussion

Pit927's avatar
Pit927
Regular Visitor
3 years ago

How can I use a parameter to select a column?

Hi!
How can I use an input parameter in the function to select a column?

Same as using ["NAME COLUMN"], then use a parameter: [parameter]
For example, in this case of combining columns:


When I introduce the parameter, I replace it within the [ ]

Because I know that if I put it in the editor as: ["parameter"] it works, but I wanted to use it as a variable for more fields..


Thank you.
All the best!

4 Replies

  • specify only the parameter name, remove the square brackets.

  • Pit927's avatar
    Pit927
    Regular Visitor

    Hi lbendlin 
    If I remove the square brackets the result is:

    IDFIELDID - FIELD
    1Black1 - FIELD
    2Yellow2 - FIELD
    3Orange3 - FIELD
    4Blue4 - FIELD
    5Green5 - FIELD


    I need this result:

    IDFIELDID - FIELD
    1Black1 - Black
    2Yellow2 - Yellow
    3Orange3 - Orange
    4Blue4 - Blue
    5Green5 - Green


    I need select the column with the name of the parameter. 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      Read about Expression.Evaluate. Make sure to read the scope part carefully.

      • Pit927's avatar
        Pit927
        Regular Visitor

        It doesn't work for me. What I need is a toString of the parameter inside the brackets to search the column. Now it's looking for Field literally.