Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: Pivot

Pivoting and Unpivoting data with pureXML part 2

Published December 4th, 2015 - by

The previous blog (http://db2geek.triton.co.uk/pivoting-unpivoting-data-purexml ) was looking at how to ‘unpivot’ data: take a string of values stored in a single VARCHAR column and present them as a set of single values. This one is examining the flip-side of the problem: where data that is really a single entity spans a number of rows and needs Continue Reading