I am pretty new here and I am getting lost.
I have a table that I bring from sql. one of the columns is an xml and I need to split the xml and them put the table back together with the new columns that the sql split have created.
so my process is (and this works)
connect to db -> read sql table -> take column -> convert to xml -> split
what i am missing is how do i put the other columns by the site and then join the columns again using some common denomitaror, so i can create a new table on my db.
please help. i am really lost.