7 Replies Latest reply: Sep 7, 2015 12:26 PM by Marco Wedel RSS

    How load necessary information from unstructured column?

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

      Hi guys,

       

      In one column I receive different information (Style, size and color). I try to determine size and color.

       

      TAFFY PINK14P       9625423
      9699439 ULTRA WHIT 2P
      ULTRA WHITXXS        9699439
      9699439 ULTRA WHIT0X/1X       

       

      I use following code for size:

      pick (WildMatch( @13, '0X/1X','2X/3X','XS/S' , '00P', '0', '1X', '2P', '2', '2X' , '3X', '4P', '4' , '6P' , '6', '8P', '8', '10P' ,'10' , '10P', '12'), 0X/1X','2X/3X','XS/S' , '00P', '0', '1X', '2P', '2', '2X' , '3X', '4P', '4' , '6P' , '6', '8P', '8', '10P' ,'10' , '10P', '12' ) AS Size

       

      Maybe you can advise better way.