Logic with Glue columns

8 views
Skip to first unread message

Tashley

unread,
Aug 22, 2019, 10:42:37 AM8/22/19
to Glue users
Hi, 
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

unread,
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
Forward
0 new messages