Can I filter a column in PN in SAP HANA with REGEX?

Projection Node is basically a graphical Calculation view. SAP HANA does not allow usage of regular expression in a graphical calculation view for filtering out data.

So if you still need to use graphical calculation view (Projection Node), then you need to filter out the data either by using a table function or equivalent.

Anil SAP Gupta

Published on 25-Dec-2017 18:42:33

• Related Questions & Answers
• Can I define a column as a table type in SAP HANA?
• Can I use Custom Error pages in SAP HANA?
• How can I freeze all tables in SAP HANA database?
• Hiding a column in Data Preview in SAP HANA
• Exporting delivery unit based on time filter in SAP HANA
• Maximum Column name length in SAP HANA
• Creating column table in SAP HANA database
• How can I filter string value with starting letter?
• How can I filter JSON data with multiple objects?
• How can I transfer data from SAP HANA to virtual table?
• Merging 2 tables with similar column name SAP HANA database
• Creating Index in Column based tables in SAP HANA
• Using column base tables in SAP HANA Calculation view with Star Join
• SAP HANA row and column store table
• Converting a Column store table to row store in SAP HANA