Join Condition

[SrinivasReddy]

Hi SAP HANA Artifacts

How can i apply Join condition Using CE Functions having columns with 2 different Column names

EMPLOYEE1

EID	ENAME	ESAL
E11	SRI	100000
E12	NIVAS	20000

EMPLOYEE2

EMPID	DEPT
E11	TECHNICAL
E12	TECHNICAL
E13	FINANACE

EMP1 = CE_COLUMN_TABLE(EMPLOYEE1,[EID,ENAME,ESAL]);

EMP2=CE_COLUMN_TABLE(EMPLOYEE2,[EMPID,DEPT]);

var_out = CE_JOIN(:EMP1,:EMP2,[.....................],[.......]);

Thanks in Advance

Regards

Srinivas

[former_member185165 · Accepted solution]

Hi Srinivas,

Use projection before join and change the name of the field using alias.

Emp1 = CE_PROJECTION(:EMP1,["EID" AS "EMPID", "ENAME","ESAL"]);

And then use the join.

var_out = CE_JOIN(:EMP1,:EMP2,["EMPID"]<field1>,<field2>..);

Regards,

Vijay

[justin_molenaur2 · Accepted solution]

I would second that approach, all you need to do is alias one of the columns to make the join. A projection will certainly do that for you.

Regards,

Justin

[SrinivasReddy · Accepted solution]

Thanks You Justin

[SrinivasReddy · Accepted solution]

Thank you Vijay

[former_member185165 · Accepted solution]

Hi Srinivas,

Please close the thread, so that it will be helpful for others to filter out from unanswered questions.

Regards,

Vijay

[Former Member]

Hello Srinivasalu Reddy,

Please do close the thread by choosing the answer given by VIJAYKUMAR as the "CORRECT ANSWER". It's  nice to appreciate ones effort and time.

Thanks and Best Regards

Mesh