DSXchange

Exactly. A proper "fixed-width file" has no need of a record delimiter, hence my question as it should be set to "None".

What did you specify as the record delimiter?

As noted, it will get you close. Afterwards you'd need to handle the "keywords" (plural) field.

With some extra pixie dust thrown in.

He just means that your "server", the "box" you are running DataStage or anything else on can be a dedicated physical piece of hardware or a small virtual slice of it. In today's world, more and more servers are virtual servers. Our hosting service provides a crap ton of servers ...

There is a Server Row Merger stage and complimentary Row Splitter as well but it doesn't do... this.

Hey, one step at a time Eric.

No, you would simply add the internal time values together.

<cough> Server job </cough>

Or is that a transform I'm not remembering?

Close but it has nothing to do with how many CPUs are involved. A physical server can be considered to be a "physical node" and can support a number of "logical nodes" as they are more akin to threads than anything else.

I would imagine it's just an IConv to get them into internal "time" format, then do the addition and then OConv the result back out again.

Interesting. Never had anyone send me a file with null values like that.

I'm assuming their resolution was a patch to correct the behavior but that wouldn't explain why it is still an issue in your version.

Yah, I don't really see this as a situation where you just throw code up against the screen and see what sticks. I would much rather have seen James's question answered or at least addressed in words rather than just seeing that posted. Sorry, I don't have a proper answer for you or I would have pos...

You would have to recognize the "Region" row as holding your pivot key and not output it, merely hang on to the value. Then as the following rows come through, populate all seven columns on each outgoing record - each one gets a region plus their "real" value and the other column...