8 Replies Latest reply: Sep 17, 2013 1:52 PM by Philippe Grenier RSS

    Unwrap table with six column pairs....?

    Brian Garside

      How would I unwrap a table that has 6 pairs of columns when it suppose to be 1 pair/two columns total vs 12.

       

      My data looks like this;

       

      UIC Level 01TOE_NAME_LEV_1UIC Level 02TOE_NAME_LEV_2UIC Level 03TOE_NAME_LEV_3UIC Level 04TOE_NAME_LEV_4UIC Level 05TOE_NAME_LEV_5UIC Level 06TOE_NAME_LEV_6

       

      Ideally it would be just two columns. But they were split.  The Unwrap wizard seems to only handle two column sets or one split?

       

      I need to split it five ways then have it stack it.

       

      Does this look correct.

       

      LOAD  [UIC Level 01] as Hierarchy_UIC,
       
      TOE_NAME_LEV_1 as TOE_NAME

      FROM
      [_Application Data\Service Hierarchy.xlsx]
      (
      ooxml, embedded labels, table is Page1_1, filters(
      Unwrap(Col, Pos(Top, 3)),
      Unwrap(Col, Pos(Top, 3)),
      Unwrap(Col, Pos(Top, 3)),
      Unwrap(Col, Pos(Top, 3)),
      Unwrap(Col, Pos(Top, 3)),
      Unwrap(Col, Pos(Top, 3)),
      Remove(Row, RowCnd(Compound,
      RowCnd(CellValue, 1, StrCnd(null)),
      RowCnd(CellValue, 2, StrCnd(null))
      ))
      ));

       

      Thanks All,

      Brian