Join using CE functions in SAP HANA database

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

Updated on: 18-Dec-2019

209 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements