Vertical pivoting
Posted: Thu Nov 23, 2000 4:16 am
A challenge for someone? (Ray )
We need to construct a job whereby we vertically pivot n * m input rows into m rows with n columns. The n for each m may not be the same! That is m1 may have 10 columns whereas m2 may have 1 and m3 may have 4.
I know I could do this by writing some preprocess code, but can we, or has someone done it via designer gui and some smart logic in a transform or something similar? If so, how performant was it?
Regards,
Phil Walker
DataStage Consultant
Project Clarity
Carter Holt Harvey Forests
DDI: 96094
MOD: 025 835 197
EMAIL: phil.walker@chh.co.nz
We need to construct a job whereby we vertically pivot n * m input rows into m rows with n columns. The n for each m may not be the same! That is m1 may have 10 columns whereas m2 may have 1 and m3 may have 4.
I know I could do this by writing some preprocess code, but can we, or has someone done it via designer gui and some smart logic in a transform or something similar? If so, how performant was it?
Regards,
Phil Walker
DataStage Consultant
Project Clarity
Carter Holt Harvey Forests
DDI: 96094
MOD: 025 835 197
EMAIL: phil.walker@chh.co.nz