Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
deesh
- Participant
- Posts: 193
- Joined: Mon Oct 08, 2007 2:57 am
Post
by deesh »
Hi, I have extracting the data from two table
Table1 Table2
Name Score Name Score
A 1 C 3
B 2 D 4
Now when i funned this data i need the data like
C 3
D 4
A 1
B 2 Please any one can helpout how it do.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
So what ARE you getting?
A funnel should produce the results you expect.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
vinsashi
- Participant
- Posts: 150
- Joined: Mon Aug 20, 2007 4:52 am
- Location: singapore
Post
by vinsashi »
First give Table 2 link to funnel then give link table1 to funnel
and in funnel stage specify funnel type sequential(generally default is continous)
Thanks
vin..
-
anbu
- Premium Member
- Posts: 596
- Joined: Sat Feb 18, 2006 2:25 am
- Location: india
Post
by anbu »
Can you show the output?
You are the creator of your destiny - Swami Vivekananda
-
abhijain
- Participant
- Posts: 88
- Joined: Wed Jun 13, 2007 1:10 pm
- Location: India
Post
by abhijain »
Could go with the work around suggested by Vinashi. I will go for sequential funnel by selecting Table 2 link as 1st link.
Rgrds,
Abhi