Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Are you using Pick-like multi-valued database as data source?
Attached is a solution to your problem.