Graphical Calculation View

[former_member254442]

Hi All,

I have SES value (field X ) in table ESSR & corresponding IR value ( field Y) in table EKBE . However, sometimes IR  may be done at later stage & at that time , I need to pick SES value ( field X) from ESSR table . i.e  If Y is null then pick X or else pick Y . How can I address this using graphical calculation view ? Thanks in advance .

BR,

[Former Member]

This message was moderated.

[pfefferf]

Join your tables using a join node and in the projection create a calculated column which uses the "if" and "isnull" function. Check the documentation Miscellaneous Functions - SAP HANA Modeling Guide for SAP HANA Web Workbench - SAP Library for the details of the functions.

Regards,

Florian