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!