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

    XML part of XLS data - how to extract

    Teppo Ojala

      Hi,

       

      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