7 Replies Latest reply: Nov 2, 2017 10:27 PM by Madhumitha C RSS

    Extracting data from Excel

    Madhumitha C

      Hello All,

      Below is the format of my source excel. I am trying to extract the break down fields (both Alphabet and the numbers) as a different table in my script. How should I approach it?

       

         

      Primary Doc noADXXXXXX
      Primary Date StartDD-MM-YYY
      Primary Date EndDD-MM-YYY
      Primary Reference125
      Secondary Doc noADXXXXXX
      Secondary Date StartDD-MM-YYY
      Secondary Date EndDD-MM-YYY
      Secondary Reference125
      Completeness% Complete
      Some long TextXX%
      Break Down
      ABC15
      QEF12
      REF3
      GAR2