Logic with Glue columns

Skip to first unread message


Aug 22, 2019, 10:42:37 AM8/22/19
to Glue users
I am trying to figure out how to use logic with the Glue Equation Editor.  Essentially, I want to replace all values in a column greater than a certain value.  Here is an example: 
If {col1}>100 then (col1}=360-{col1}
I tried writing this in a couple different ways (e.g.: {col1}[{col1}>100]=360-{col1}), which is python format, but I am not having any luck.  What is the proper format for logic in the equation editor?  
Thank you!

Hope How-Huan Chen

Aug 22, 2019, 12:37:08 PM8/22/19
to Glue users
It may not be only answer, but what you are describing is similar to what the example of "Use masking" in the equation editor does.  It will be (360 - {col1})*({col1} > 100) + {col1}*({col1} <= 100) in this case.  
Reply all
Reply to author
0 new messages