Search found 3 matches
- Wed Oct 19, 2011 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to properly use pivot/pivot enterprise
- Replies: 6
- Views: 2145
@chulett - That's what I was thinking I would have to do but wasn't sure if there was an automated way to do it. I just thought of something once I stepped away from the computer for a few minutes to clear my head so I will post back tomorrow whether or not it worked. @ray - The other columns only g...
- Tue Oct 18, 2011 8:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to properly use pivot/pivot enterprise
- Replies: 6
- Views: 2145
If I derive MEASURE from those values I will only get the values, what I need is the Column header to be pivoted down alongside the value. From my initial post with the way pivot works by default the proposed ending format would be lacking the last column DIMENSION. @Ray - Thanks for the idea though...
- Tue Oct 18, 2011 9:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to properly use pivot/pivot enterprise
- Replies: 6
- Views: 2145
How to properly use pivot/pivot enterprise
I am in the process of transforming US census data so that it is conforming with my database format. Starting format: GEO_ID2 SUMLEVEL GEO_NAME B15002A_1_EST B15002A_2_EST B15002A_3_EST 107000 160 Birmingham city, Alabama 44000 20500 1017 121184 160 Dothan city, Alabama 30326 14155 577 135896 160 Ho...