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.