DSXchange

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...

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...

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 .

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 ...