i am trying to use cross apply for this transformation, but its not working could someone please helpselect * fromtable namecross apply string_split(columnname, ' , ‘ )i tried even this but not workingselect *,t2.value fromtable name as t1cross apply...