0 Replies Latest reply: Feb 26, 2016 7:50 AM by Виталий Чуприна RSS

    Separate part of table

    Виталий Чуприна

      Good Morning,

       

      Could someone advise nice way how to solve following problem. I have files with many small tables, each tables contains different stores and applies to different department. The problem is that department numbers are placed above tables.

      First I tried to use enable transformation step, but in this case I should load data without header line (columns name) and its makes some problems:

      original files have a lot of columns and if in future if file structure will be changed I will load wrong data into database.

      Please see example of file in attachment

       

      Department: 609
      CODENUMNAME WTD UWTD U LYMTD U MTD U LYSTD U STD U LY
      DFR155VIENNA100001720017200
      321LONDON000000
      985LIVERPOOL0003000000
      635KIEV001100017000
      742MADRID009000000
      159ROME0000085000
      Subtotal 100001182030000342085000