How to transpose this Excel data (suggetions appriciated)

WoMaWil · Post by **WoMaWil** » Wed May 23, 2007 5:28 am

this is a very standard problem (normalize/denormalize) which is relativly easily to be solved.

Let me know if you don't find a solution by searching in this forum.

ray.wurlod · Post by **ray.wurlod** » Wed May 23, 2007 5:55 am

This is a pivot; it can be done with a Pivot stage. Over-configure the number of pivoting columns, then filter out those generated with NULL in the result.

paradize · Post by **paradize** » Wed May 23, 2007 6:27 am

thnx for repling

ray.wurlod wrote:This is a pivot; it can be done with a Pivot stage. Over-configure the number of pivoting columns, then filter out those generated with NULL in the result. ...

How can i remove rows from the column defination when they r null
pls explain
as my columns will keep on increasing by time how much can i over-configure it

chulett · Post by **chulett** » Wed May 23, 2007 6:48 am

Filter them out post-pivot with a simple "Not(IsNull())" constraint in the transformer after the pivot stage.