5 Replies Latest reply: Feb 7, 2016 5:44 PM by Marco Wedel RSS

    Multiple data columns to one

    P M

      Hi I have a data set like below

       

      CustCode     Group1     GroupOther

      A                    X               Z;;;;;;;

      B                    X         

      C                    Y               Z;;;;;;;;

      D                    Y

      E                    Z

       

      Group1 is the basic link between customers but where a second set of grouping is required you can enter up to 8 further groups which are stored in GroupOther with a ; as the separator.

       

      I know how to split the GroupOther fields during the load and give each field a name.

       

      I need my final data so if I select Z from Group1 I fileter to E AND A AND C not just E