IF ELSE EVAL() execution error

1

Hi,
I’m taking column names in parameter after that if that parameter contains single column name then simply evaluating that column and if contains multiple column names in parameter then printing else part, but when i’m passing multiple column names it’s execution eval() function also it should not execute that part it should execute else part. please help.

image
image1366×768 99.2 KB

Deduplicate dynamic columns.morph (3.9 KB)

2

In an expression, the eval() function is always evaluated first (pre-evaluated), and only then the whole expression is evaluated for every row. Therefore, the correct syntax is:

eval(
    IF not contains({Columns}, ',')
    THEN
        '[' & {Columns} & ']'
    ELSE
        '"Multiple columns"'
)

Notice that '"Multiple columns"' is wrapped in quotes twice (single quotes and double quotes) because it must evaluate to "Multiple columns" (a valid text constant), not Multiple columns (which would be an invalid expression).

See also the example below:
test-eval.morph (3.2 KB)

3

Thanks @dgudkov.