SAP HANA Graphical View , calculated column, multiple match values

[WANGWU]

Hi experts,

How to write the multiple match values of calculated columns in SAP HANA Graphical View ?

For example,  like 1001* and like 1002* and like 1003*......

The input 1001*,1002*,1003* not work.

Tks.

[HakanHaslaman]

SAP HANA Calculated Columns do not support direct wildcard filtering with multiple values like "1001*,1002*,1003*".

May a possible workaround could be to use CASE or IF conditions:

CASE
WHEN COLUMN LIKE '1001%' OR COLUMN LIKE '1002%' OR COLUMN LIKE '1003%'
THEN 'Match'
ELSE 'No Match'
END

If using Input Parameters, consider dynamic SQL or a filter node with multiple OR conditions.