I have to create a new calculated column based on a formula applied to a column from my input table. The formula is not fixed; the user specifies this formula at the execution time. I thought I could do this with a column expressions node but I was unsuccessful.
i don’t think that might be the solution of this usecase.
i’ll want to simply bypass a node that has been put “down” because a string configurator node is injecting a wrong formula. Can some try/catch node resolve this issue?
I understand but that is not possible with Try/Catch nodes cause they catch errors during execution while Column Expressions throws error during configuration in this case.
Looking from a use case perspective. If a user inputs wrong expression workflow can continue to execute but results are not going to be correct. This means user has to run workflow again and again until expression is right. So if I’m designer or user running workflow I would prefer to throw/have syntax error right away and not wait till execution is done, then check results and go back to same workflow…