Selecting current value

[#1]

I have case in which i want to select latest one entry

my data is as below

Project_Name Start_Date End_Date

ABC                12-12-15    12-12-16

ABC                13-12-16     Null

CDE                1-1-15        12-12-15

CDE                13-12-15     Null

i want output

Project_Name Start_Date End_Date

ABC                13-12-16     Null

CDE                13-12-15     Null

[vishsaggi]

Try this?

LOAD * INLINE [

Project_Name, Start_Date, End_Date

ABC                ,12-12-15,    12-12-16

ABC                ,13-12-16,     Null

CDE                ,1-1-15  ,      12-12-15

CDE                ,13-12-15,     Null

]

WHERE End_Date = 'Null';

OR if data is coming from an excel

LOAD Project_Name,

          Start_Date,

          End_Date

From [..\Desktop\YourexcelFilename.xlsx]

(ooxml, no labels, table is Sheet1)

WHERE End_Date = 'Null';

[sunny_talwar]

Another option

Table:

LOAD * INLINE [

Project_Name, Start_Date, End_Date

ABC, 12-12-15, 12-12-16

ABC, 13-12-16, Null

CDE, 1-1-15, 12-12-15

CDE, 13-12-15, Null

];

Right Join (Table)

LOAD [Project_Name],

  Max(Start_Date) as Start_Date

Resident Table

Group By Project_Name;