6 Replies Latest reply: Dec 26, 2017 3:48 AM by Victor GREFFET RSS

    Multiple Load keeping inital matrix

    Victor GREFFET

      Hi community,

       

      I'm stuck on a something simple but i need your help, what I would like to do :

      My initial matrix is:

      ID

      Step
      1A
      2B
      3C
      ...D
      nn

      I would like :

      IDTestlevel
      1ALevel 1
      2BLevel 1
      3CLevel 1
      ...DLevel 1
      nnLevel 1
      1

      A

      Level 2
      2B

      Level 2

      3CLevel 2
      ...DLevel 2
      nnLevel 2
      1ALevel 3
      2BLevel 3
      3CLevel 3
      ...DLevel 3
      nnLevel 3

       

      (Repeat initial matrix with attribute level, 1 to 3)

       

      I tried :

       

      [Feuil1]:

      LOAD *

      FROM [lib://Downloads/test.xlsx]

      (ooxml, embedded labels, table is Feuil1);

       

       

      Load

      *,

      'Level 1' as level

      resident Feuil1;

       

      Load

      *,

      'Level 2' as level

      resident Feuil1;

       

      Load

      *,

      'Level 3' as level

      resident Feuil1;

       

      But I have Syn1 Table created in my data model :

      Capture.PNG

      I'd like to clean that,

       

      Do you have an idea ?

       

       

      Thanks,

      Victor