6 Replies Latest reply: May 22, 2013 6:22 AM by hassamahmed RSS

    Kindly help me in creating the script for this data.

      Hi,

       

      I have to write a script for this sort of data. how it would be possible?

       

      As this is just a dummy data which i have on my excel sheet.

       

      I have multiple sheets all containting the same number of fields but with different dates.

       

       

      For the month of JAN




      Total
      Shift
      ABC
      Calls
      14161242
      Follow-upLater 1061026

      Not Interested410216
      [Day:Tuesday 01/01/2013]




       

      I wrote up this simple script :

       

      LOAD Shift,

                  Calls,

                  [Follow-up],

                  [Day:TUSEDAY 01/01/2013]  as Day

       

      FROM

      [D:\Dummy Daily Report.xlsx]

      (ooxml, embedded labels, header is 1 lines, table is [1 JAN], filters(

      Transpose(),

      ));

       

      But Follow-Up fields contain two Sub-fields (Later,Not interested) and kindly help me with the date aswell.

       

      Please help me in creating the correct script.

       

       

      Thanks..