6 Replies Latest reply: Feb 4, 2016 11:07 AM by Виталий Чуприна RSS

    How to compare data from different lines

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

      I receive files that contains Style and color information in different lines, in additional they haven't any original part, that I can use to join data. See example below:

       

      All Sales Regions  -  CONSIGNMENT PHANTOM.RBK\W255C836A-ONL\L/S TOP CAMDEN
      All Sales Regions  - CONSIGNMENT PHANTOM.BLACK
      All Sales Regions  - CONSIGNMENT PHANTOM.RBK\W255C946A\L/S TOP THEO
      All Sales Regions  - CONSIGNMENT PHANTOM.GREY
      All Sales Regions  - CONSIGNMENT PHANTOM.WHITE

       

      How in this case load data correctly(style with necessary color)?