Hi all,
I have an issue, when I am trying to Join two Dataset files. If I join them using a Look-up stage, I get the desired output. However, If I use Join/Merge with the same keys, I am not getting the desired output.
Also, some of my records also has null values, but I am not joining them using Join/Merge.
Has it got anything to do with this. I am stuck here can anyone please throw some light on this issue.
Thanks!!
Joining two datasets.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Please post/provide a sample of your desired output and the current undesired output with the inputs for the same. May that will help us understanding your problem better.
Regards,
Whale.
Regards,
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Thanks for the reply.
Have two datasets with the following columns:
first_name, Mi_Name, Lats_Name, Gender, Birth_dt
adam , l, supko, M, 1985-06-20
sri , k, kumar,
tia, suder, f , 1978-07-20
I am trying to join the two datasets through first_name, Mi_name, Last_Name, Gender, Birth_dt to extract the "person_sk" from the second dataset.
If use a Look-up then I get distinct "person_sk" for each distinct person.(with 260 records)
If, I use join/merge:
1. it is dropping most of the records when using the same keys as above.
I would really appreciate, if you can throw light on this issue. I can't figure out whats going wrong.
Thanks!
Have two datasets with the following columns:
first_name, Mi_Name, Lats_Name, Gender, Birth_dt
adam , l, supko, M, 1985-06-20
sri , k, kumar,
tia, suder, f , 1978-07-20
I am trying to join the two datasets through first_name, Mi_name, Last_Name, Gender, Birth_dt to extract the "person_sk" from the second dataset.
If use a Look-up then I get distinct "person_sk" for each distinct person.(with 260 records)
If, I use join/merge:
1. it is dropping most of the records when using the same keys as above.
I would really appreciate, if you can throw light on this issue. I can't figure out whats going wrong.
Thanks!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: