Skip to Content
0
Former Member
Aug 06, 2016 at 01:22 AM

How to populate null values in first table by joining 2nd table which has required values

34 Views

Hi,

I am learner in HANA, i have a requirement where i have a Calculation view 1 which contains full data with null start dates for some of the records since it was not available during the time of creation of CV.

Now, we received flat file which contains the data for mussing records in Calc view 1. I need to populate these null records by doing a join/union with the table (flat file) i imported in hana. Below is my scenario, i would like to know what is the best procedure to achieve this.

CV_1: TABLE 2

ID Startdate Employee ID Startdate

1234 2014-07-21 Mike 2314 2015-03-12

2314 NULL Hary 2314 2016-04-14

3241 NULL Lisa 3241 2015-07-11

3218 2015-04-02 Perl 3241 2015-10-21

1)How can i populate the NULL values in CV_1 from TABLE 2?

2)Since 1 ID from TABLE 2 has multiple dates, i want to take the latest date from it only.

Thanks in advance.