I have a table Sample with data stored like below

Id   | String
--------------
1     abc,def,ghi
2     jkl,mno,pqr

I need the output like..

Id   | processedrows
--------------
1     abc
1     def
1     ghi
2     jkl
2     mno
2     pqr

I run in SQL server successfully with XML table.

select a.Id,trim(COLUMN_VALUE) 
FROM tableA a ,xmltable(('"'|| REPLACE(a.String, ',', '","')|| '"'))

How can I do the same with a select query in netezza?