Regarding funnel

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

Post Reply
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

Regarding funnel

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
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
Post Reply