Hello community,
I need a node or a method which is equivalent to the IF(ISNUMBER(FIND(“Samsung”,F4)),“Samsung”,“Else”)
However. i ll need to do it for every brand.
You can use the Rule Engine or Column Expressions node.
Assuming all the brands are in a column called Brand, then
the Rule Engine node would be configured with an expression such as
$Brand$ LIKE "Samsung" => "Samsung"
TRUE => "Else"
and the Column Expressions node would be configured with an expression such as:
if (contains(column("Brand"),"Samsung") == true)
{"Samsung"}
else
{"Else"}
oh thank you. i don t know why i couldn’t think of it
I have just tried now, and it is not working. it returns only else
I have just tried now, and it is not working. it returns only else
This is not very informative. I gave 2 options - what exactly is it that you tried? Did you modify the expressions in any way?
It would be best if you shared the workflow so we can see how you configured the nodes.
I think this would need “*”:
$Brand$ LIKE "*Samsung*" => "Samsung"
thanks a lot it is working now
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.