Hi everyone,
I'm quite beginner in some PX Stage like "Promote Subrecord" and i have
some questions :
my record look like this :
a,b,c,d
a,e,f,g
b,h,i,j
b,k,l,m
and i want the following result :
a,b,c,d,e,f,g,h
b,h,i,j,k,l,m
1) can the "Promote Subrecord" stage do this ? i guess yes, but i want to be sure about this
2) I tried to use it but it always return me the error message
"Not an aggregate field" !!! what does it means ?
3) How to use this stage (Input/Output), it's very weird !!
Thanks
Chanthou
Help en Promote SubRecord
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 11
- Joined: Mon Jun 16, 2003 2:21 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could split the stream into two copies, run one copy through a Promote Subrecord stage and join the two copies subsequently, selecting appropriate columns from each input to the Join stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.