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
Published on 15-Dec-2017 20:43:38
Advertisements