Hi,
I have two datasets with same no.of columns and rows.
I want to join these datasets and the output dataset should have same num of rows.
Is there any method apart from lookup.
Table 1
A B
1 2
1 4
Table 2
A C
1 3
1 5
and I want the output like
A B C
1 2 3
1 4 5
Thanks in advance
kcs
joining datasets
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 108
- Joined: Wed Jul 28, 2004 7:15 am
Hi,
look at the join,merge stages
I think you will find that a lookup is probably the fastest way.
IHTH,
look at the join,merge stages
I think you will find that a lookup is probably the fastest way.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Hi Prashant & Roy,
thanks for your reply.
Prashant, Column A is a dummy column in my job and I tried using that but iam getting duplicate rows.
I want output dataset of same num of rows as of source(ie both my source file have 1000 rows, i want the resulting file of 1000 rows).
Thanks in advance
kcs
thanks for your reply.
Prashant, Column A is a dummy column in my job and I tried using that but iam getting duplicate rows.
I want output dataset of same num of rows as of source(ie both my source file have 1000 rows, i want the resulting file of 1000 rows).
Thanks in advance
kcs
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom