Jump to content

Is there a way to check if a column exists and if it does include in a formula


Recommended Posts

Hi Griz, 

yes, there are multiple way to perform the changes of the attributes name using a formula, the one that I suggest you is the following.

Let's take as example a data set containing 3 attributes:

  • CLIMBER, name of the climber
  • Best Sport, the highest sport grade reached by the athlete 
  • Best Boulder, the highest boulder grade reached by the athlete



You decide that "Best" is not representative enough and you want to change the names of all the attributes containing "Best" by replacing "Best" with "Highest".

To do that you need to:

  • Insert $names on the left side of the formula
  • Insert the formula that you want to use on the right side, in this case:
     ifelse(find ($names, "Best") == 1, replace ($names, "Best", "Highest"), $names)



I hope it will be useful to you 

Link to comment
Share on other sites

Hello Griz, 

thank you for opening this topic on our Community.

By specifying the $names parameter in the left-hand side member of the formula bar in the Data Manager task, you can bulk edit the dataset's attributes' headers.

You can find more information about this specific use case on the technical documentation at the following link: Computing Formulas in the Data Manager (rulex.ai).

If you need further clarification, don't hesitate to contact us!

Have a wonderful weekend.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...