I read on the following blog http://it.toolbox.com/blogs/infosphere/ ... e-85-42312 by Vincent McBurney
that the new transformer in the DS 8.5 gives the key change option but I could not locate this new property in the new transformer stage. I saw one new thing though, the transformer stage now can do a looping mechanism, which is pretty cool. With this looping mechanism horizontal pivot can be done inside of the transformer stage itself. We can also use the looping mechanism just like the for loop, do-while loop.
Can someone point me to the right direction in finding the keychange option in the new transformer stage (DS 8.5) ?
Apologize if this question was answered in previous posts.
Where is "Key Change" option in the new transforme
Moderators: chulett, rschirm, roy
Where is "Key Change" option in the new transforme
Regards
Kashif Khan
Kashif Khan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The new LastRowInGroup() function is in the Parallel Job Dev Guide under Key Break Detection and requires sorted input. I haven't used the new function yet. It sounds similar to but perhaps opposite from the keyChange column from the Sort stage. LastRowInGroup() is true on the last row before the key changes whereas keyChange is 1 on the first row in each group. Please correct me if I'm wrong. I have used the new loop variables and they work like a charm!
Choose a job you love, and you will never have to work a day in your life. - Confucius