HOW TO De-normalize datapivot rows into columns.doc

Problem Description
The Normalizer transformation is used to "normalize" data, or to pivot columns into rows. How can you do the opposite (de-normalize, denormalize), or pivot multiple rows into multiple columns in a single row? Suppose you have a source table with this data that is a record of monthly expenses for each of your Sales Reps:

初级会员 注册时间: 2008-07-04 04:35:31 文章: 10 离线

感谢lynx286,但如果遇到需要normalize or de-normalize的col所包含的列值是动态增加的或不固定的，不知道这样infa该如何处理了，lynx286有没有好方法？

初级会员 注册时间: 2008-05-02 01:49:03 文章: 23 离线

还没有这样的需求

中级会员 注册时间: 2009-05-05 06:35:31 文章: 35 离线

Thanks!