Column Expression x Expression (Part 2)

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
image

Hey there,

first of all - thank you for the very comprehensive description and information.

To get to your question:
I think that Column Expressions provided (and still provides) a lot of flexibility that go beyond the predefined formula - my understanding is that under the hood it is using Java Script and thus you can do if statements, define variables - even define entire Java Script functions.

That flexibility to the best of my knowledge does not exist anymore in Expressions node - which also means that not everything you can do with Column Expressions can be done in Expressions right now (which is why I am still frequently using Column Expressions in some cases).

With regards to array and file functions - my understanding is that this is right now not built into Expressions. But I also understand that Expressions is supposed to combine a lot of functionality that is separated out into different nodes (String Manipulation, Math Formula, Rule Engine, Column Expressions…) and that therefore the functionality will be further extended as time progresses…

Would be great to see a roadmap or something to better understand when what new functionality will be added. I still use Column Expressions for manipulating Paths etc. This right now doesn’t work in Expressions yet either.

Just want to stress: Don’t get me wrong -I’m a big fan of Expressions. Especially combined with K-AI it makes my life a lot easier - but not yet replacing Column Expressions for me.

3 Likes

Hi

I just watched this video, and the scientist talked about “expression” vs. “column expression.”

See at 37 min:

1 Like

Watching your channel Martin
https://youtube.com/@lowcodeaiforthewin-fx2bo?si=bsdduQFMDAE-ijZC

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.