Join using CE functions in SAP HANA database

SAP HANASAPSAP Basis

You can try using projection node as follows

Example

table1 = CE_PROJECTION(:T1,["ACCT_ID","SALARY"]);
table2 = CE_PROJECTION(:T2,["EMPL_ID" AS “ACCT_ID”,"ADD","ZIP","STATE"]);
var_out = CE_JOIN(:table1,:table2,[“ACCT_ID”])

Using Projection node, you can rename the column names. Note that EMPL_ID has been renamed to ACCT_ID

raja
Updated on 18-Dec-2019 07:42:39

Advertisements