Column Expressions Node

#1

Hi,

I’m trying to familiarize myself with column expressions node but having difficulties, can someone help me write out an “if contains” statement?

I’d like to say:

if column(A) contains “category” or “value” or “data
then column (B)
else “”

I know that I can do the same thing in rule engine and I was able to accomplish this statement in that node but I really want to understand column expressions node and how to write statements in it.

Thank you for your time!

0 Likes

#2

if (indexOf(Column(A), “category” > -1 | indexOf(Column(A), “value” > -1 | indexOf(Column(A), “data” > -1 |) {Column(B)}
else {""}
Did not check but should be like this one.

0 Likes

#3

Does not seem to work

Capture

0 Likes

#4

This one is more accurate. Anyway, you will need to replace " they not copies correctly.

1 Like

#5

@UnknownValue

This should work:

if
(indexOf(column(“Column A”), “Category”) >= 0
|| indexOf(column(“Column A”), “Value”) >= 0
|| indexOf(column(“Column A”), “Data”) >= 0)
(column(“Column B”);
else “”;

2 Likes

#6

Hi Tardis Pilot,

This works, thank you! :slight_smile:

2 Likes

closed #7

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

0 Likes