10 Replies Latest reply: Nov 26, 2012 5:12 AM by Grace Rashmi RSS

    How to load the Min date

      Hi,

       

       

      I have a table :

       

      Date | Call No | status

       

      i want to load the min(date) of a perticular call no where status is 79 or 13...

       

      Can any one help me to write the code for this

       

      i tried this but it is not working

       

      LOAD

      min(Date) as MDate,

      Call_no,

        Status

      FROM [E:\Call Flow.xlsx] (ooxml, embedded labels, table is Day1) where status=79 or status=13;