DSXchange

Thanks everyone!!!!!!!!!! It's solved, after all it wasn't that hard. I used stage variables in a transformer. One reason it was easy is because i only have one column. This is my next problem. Now that I have it divided in each section in a separate flat file I need to transfer my rows into columns...

Ok, finaly I got my premium member ship :-) This is how my data looks like. It comes with one data on each line. So it's diffrent from what I thought. _______________________________________________________ FILE NAME - Start SEQ-1 <-----Seq 555 666333 4444 -END SEQ-2 <-----Seq 2223333 333 5553 33344...

Seems like it's time for me to go Premium...

...have to talk to the boss.

Thanks for the help, I wil try it soon, I hope!

Ok so it is possible, I havent seen the file yet, just wanted to check before I ask for it. I will try as soon as I get it. Most likely there will be some more posts. If it works I will post my answer and close the case.

Thank you!

Hi, I have a txt file that comes in diffrent sections: #section1 1 test1 test2 test3 2 aaaa bbbb cccc 3 uuuu eeee rrrrr #section2 1 test1 test2 test3 tyty 2 aaaa bbbb cccc tyty 3 uuuu eeee rrrrr tyty 4 test ett s ttett #economy 1 56 Q1 2 56 Q2 ... The sections will have diffrent names and they will ...

Depending when you have time for that beer ;-) Now Santigo, in the future it will be in Sthlm.

I feel like the new kid on the block needing this much help!

Now it works and it is beautiful. Thank you very much. If you ever come by Santiago or Stockholm, let me buy you beer ;-)

//Mattias

Ahh but If I run it through another transformer and check with the output file from the first transformer I can delete all instances of the dealnumbers that corresponds to the dealnumbers in theoutput file from the first trd.

That should work, but first lunch!

//Mattias

But I think my problem is a more complicated than that. If a dealnumber is repeated I want to remove all the rows containing the dealnumber. I dont want to keep any of them. If I only check if it is the same dealnumber with the row below I will always get one dealnumber left, or am I wrong. 10 100 1...

Thanks, I will look into your answer, seems kind of complicated but I'll give it a shot. I guess I have to learn in which forum I have to post my questions aswell :-(

Thank you.
//Mattias

(If it solves my problem I'll get back and mark my question as solved.)

Hello! I would like to identify duplicate dealnumbers. If a dealnumber is shown one time it's ok. If the same dealnumber is in two rows or more I want to remove the rows and insert them into another output for further use. This seems to be easy but i cant figure out how. Thank you for your help, Mat...

THANK YOU! IT WORKS!!

It only took a day;-) The last piece of code did it. Perfect. I'm very VERY greatful.

Have a really nice day.

//Mattias

Ok, you are right, thanks for listening to me. Here we go again: Two feeds and one transformer and one aggregator. Feed1: --> all char (char comes into the job) --> Hashed -->decimal, 4 (hased output is decimal) --> Aggregator, sums two fields, groups on 4 (Decimal, 4 as input/output) --> Hashed -->...

Not sure I got that. No one in my office can solve this problem. It sucks! What is the best way to change the data type? How do I change it to char. Thank you all for all your help, I really apprieciate it. //Mattias [quote="kcbland"]No. DataStage doesn't care what value you ASSIGN to a va...

Nope no nulls. But a question. Is there a difference if I enter a 0 or a "0" in a char field?