10 Replies Latest reply: Sep 14, 2013 6:47 PM by Nagaian Krishnamoorthy RSS

    How can i resolve problem with multi values in a cell

    zubair khan

      Hi All

       

      I have a scenario where some fields have multi values with a separator in different columns, i need to separate these values and insert in new row , for example:

       

      ID     CustID     Int_type          int_amt

      101     2001     PE%PS%PI     20.75%101%0

      102     2002     PI%PE               1009%2.5

      103     2003     PS%PE%PL     0%15%10

       

      how do i  want to load into qlikview is

       

      ID     SubID     CustID     Int_type          int_amt

      101                    2001     PE%PS%PI     20.75%101%0

      101     1             2001     PE                    20.75

      101     2             2001     PS                    101

      101     3             2001     PI                         0  

      102                    2002     PI%PE               1009%2.5

      102     1             2002     PI                        1009

      102     2             2002     PE                        2.5    

      103                    2003     PS%PE%PL     0%15%10

      103     1             2003     PS                    0

      103     2             2003     PE                    15

      103     3             2003     PL                    10

       

      Thanks in anticiapation.