Hi friends
Another Comparison Between Column Expression vs. Expression Node
In this thread:
There was a discussion about the Column Expression node and the Expression node.
Since the thread is closed, I’m following up with another question about the Expression node.
Column Expression
As the Column Expression has become “legacy,” I thought it would be a good opportunity to start using the Expression node. However, I encountered a peculiar situation:
In the Column Expression node, there is a list of functions that I often use as a reference. For example, the list includes array functions and even functions like getFileProperties. (see screenshots). The list has been very helpful, and over time, with help from forum members, I’ve also discovered some additional formula techniques that aren’t explicitly listed but are still possible.
For instance:
- Using an IF as a ternary expression.
- Storing a value in a variable.
- Implementing a “switch-case-break-default” logic.
These are JavaScript rules that aren’t included in the function list but can still be used.
Column expression function list
Column expression function list
Expression node
When I started exploring the Expression node, I made a comparison with the functions available in the Column Expression node and noticed that several functions are missing from the Expression node’s list.
Additionally, the syntax of functions is different.
For example, writing an IF statement in the Column Expression node differs from how it’s written in the Expression node. This means there’s a learning curve involved.
Perhaps the Expression node uses a syntax closer to the Java language.
The practical issue:
When I tried using the Expression node, I was looking for the function getFileName
, which is available in the Column Expression node. I also wanted to use the arrayContains
function, which is also missing in the Expression node.
Since these functions aren’t listed in the Expression node, my question is:
- Are these functions present but hidden in the Expression node?
- Is there a comprehensive list of all functions that can be used in the Expression node, including those not explicitly shown, with examples?
In summary:
I’m still not confident in using the Expression node. I expected it to be a significant update, but it’s proving to be a challenge.
Expression node function list
missing function