Split string field into table rows

[#1]

Hi,

I am facing the following problem.

I have table A like this:

ID    I     INVOICE

1     I     S200/M250/R35/

2     I     M1687/A35/D879/F689/

3     I     B33625/S55/

For each "ID", I need to split the "INVOICE" string field as shown below :

ID    I     INVOICE

1     I     S200

1     I     M250

1     I     R35

2     I     M1687

2     I     A35

2     I     D879

..............................

3     I     S55

Any idea how to do it?

Best regards.

[Anonymous]

Hi,

Thanks For u r example

@ mona_qlik