Search found 4 matches
- Tue Oct 04, 2022 8:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need help to cleanup table
- Replies: 1
- Views: 20370
Need help to cleanup table
Hello all, I made a mistake and need to cleanup a table. After run 120 I noticed my wrong join and now I need to clean duplicated data. But I can't figure out how to do this. Anyone who can help me a little? In attachment I took a screenshot from my sampledata. So I only need to keep the green lines...
- Mon Jan 17, 2022 6:59 am
- Forum: General
- Topic: Same lookup on multiple rows
- Replies: 1
- Views: 9399
Same lookup on multiple rows
Hello all, I have a sequential input file with + 100 lines. But there are codes in these lines and I need to replace them with numbers. Is there an easy way to do this? Codes : MS = 8,1 / AS = 8,1 / N = 9 / WEN = 11 / WED = 11 / N-TW = 9 input: ID 1 2 3 4 5 6 7 650692063 MS MS MS MS MS 780844037 WEN...
- Thu May 09, 2019 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in creating transposed file
- Replies: 8
- Views: 6732
The input is a massive amount of DB2 data .
I made a little example to show what I was looking for.
https://ibb.co/BcH3Kmv
I guess it's not going to work .
I made a little example to show what I was looking for.
https://ibb.co/BcH3Kmv
I guess it's not going to work .
- Sun May 05, 2019 9:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in creating transposed file
- Replies: 8
- Views: 6732
Need help in creating transposed file
Hello all, I'm new to this forum and I realy hope someone can help me. My problem is that I need to create a file with data from a DB2 database. The file should look like this ID ID2 Col1 Col2 Col3 11 1 12 2 12 3 15 1 12 4 9 12 4 16 2 20 16 Col1 to ColX are values, and the ColX because I don't know ...