April 16, 2013 at 12:34 pm
I have two oledbsources. One oledbsource has the distinct list of product ids (DataSet A) and another oledbsource has all of the order information with product id (DataSet B). How do I get all those orders (DataSet B) that have product ids in DataSet A?
For example:
Dataset A
product id
1
2
Dataset B
order id product id
1 1
2 1
3 1
the result set should be
order id product id (DataSet A)
1 1
2 1
3 1
The Merge join transformation didn't give the desired results.
April 16, 2013 at 1:21 pm
rs80 (4/16/2013)
I have two oledbsources. One oledbsource has the distinct list of product ids (DataSet A) and another oledbsource has all of the order information with product id (DataSet B). How do I get all those orders (DataSet B) that have product ids in DataSet A?For example:
Dataset A
order id product id
1 1
2 1
3 1
Dataset B
product id
1
2
the result set should be
order id product id (DataSet B)
1 1
2 1
3 1
The Merge join transformation didn't give the desired results.
join the two tables on productId?
ps...are you sure your explanation of which data set is which is correct?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 16, 2013 at 2:12 pm
You were right. The datasets were referred incorrectly.
In the merge join transformation, when I do an inner join I only get 1 record back. However, when I do a t-sql query I get all 3 records back.
April 16, 2013 at 2:18 pm
rs80 (4/16/2013)
You were right. The datasets were referred incorrectly.In the merge join transformation, when I do an inner join I only get 1 record back. However, when I do a t-sql query I get all 3 records back.
care to share your code?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply