3 Replies Latest reply: May 13, 2015 5:56 AM by Teppo Ojala RSS

    XML part of XLS data - how to extract

    Teppo Ojala



      I found couple of quite similar cases here, but yet I haven't solved my problem.


      Attached a xls file that consists of two columns


      A = Group name

      B = XML information about which products belongs to the GROUP from column A. One GROUP can have 1-X products.


      In this example GROUP 1 should have 4 products (A, B, C and D) - and GROUP 2 should include only two products (A and B).


      I couldn't write a script that would return a data model with 1 or 2 tables where groups are linked to correct products.


      Hopefully somebody here has skills for this