Search found 2 matches
- Wed May 29, 2019 1:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Source file Structure in Columns not rows
- Replies: 5
- Views: 4243
That's correct the data is stored in the columns. I reformatted the source file for better reference. I never worked with data in this format. I'm looking for suggestions on the best way to process the data. Account#1 Account #2 Account#3 Account Type Master Checking Savings Account ID 123 987 654 B...
- Mon May 27, 2019 9:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Source file Structure in Columns not rows
- Replies: 5
- Views: 4243
Source file Structure in Columns not rows
Looking for guidance on how to process a file that is in the format below. I was having trouble using the pivot stage and wanted to see if there were any other ideas. Account#1 Account #2 Account#3 Account Type Master Checking Savings Account ID 123 987 654 Beginning Balance 1000 550 450 Indirect Ac...