Passing non-group columns from Aggregator Stage

ds2000 · Post by **ds2000** » Thu Dec 06, 2007 4:49 pm

I want to pass through Non-Group columns (char and date type) from the Aggregator stage. I can't use join stage to combine columns back.

what conversion code i have to use for Char and Date type to pass the data from Aggregator using Max function.

Or any other suggestion ?

ray.wurlod · Post by **ray.wurlod** » Thu Dec 06, 2007 5:44 pm

Get your head around the fact that you can use Join stage to join the columns back. If "they" say you can't (that is, aren't allowed to), then fight it out with "them".

ds2000 · Post by **ds2000** » Thu Dec 06, 2007 6:03 pm

Any Other suggestions ?

ray.wurlod · Post by **ray.wurlod** » Thu Dec 06, 2007 7:52 pm

It's known as a "fork join" design.

Code: Select all

----> Copy  --------------> Join ---->
       |                     ^
       |                     |
       +---> Aggregator -----+

ray.wurlod · Post by **ray.wurlod** » Fri Dec 07, 2007 1:15 am

ds2000 by Private Message wrote:I was not able to see the complete message and if i can get the details of it. I would subscribe to premium membership now.

"If you give me a dollar for a hamburger today, I will gladly repay you next Tuesday."
J. Wellington Wimpy

Premium membership, as I am sure you have already read, is about paying for the hosting and bandwidth costs incurred by DSXchange. Thus I am unwilling to create any precedent of subverting it. I regard DSXchange as a valuable resource. That's why I support it. Unconditionally.