Last post Mar 11, 2015 03:56 PM by muhammadazeemazam
Mar 11, 2015 02:05 PM|muhammadazeemazam|LINK
Hi I have tje following Datatable
i want the following Ouput
i am able to get the following but using UnPivot but my column 2 is not according to above table
How can i solve for that.
Mar 11, 2015 03:23 PM|gimimex|LINK
when 'Column3' then 1
when 'Column4' then 2
end) as Column2,
ColValue as Column3
ColValue for ColName in (Column3, Column4, Column5)
) as u
Hope this helps.
Mar 11, 2015 03:31 PM|muhammadazeemazam|LINK
Parse function works with only 4 Parts.
What if i have 16 or more Parts.
Mar 11, 2015 03:56 PM|muhammadazeemazam|LINK
solved for just 4 parts.