Join Stage
Moderators: chulett, rschirm, roy
Join Stage
I have 2 inputs say file1 and file2 to a join stage.
Both the inputs have 6 fields. Now the output should contain 3 fields from the file 1 and 3 fields from the file 2.
Fields in File 1 and 2
name
address
city
state
phone
email
Now in my output I would like to see name, address,city from file 1 and state, phone, email from file 2. Is there a way we can achieve this ?
Thank you.
Both the inputs have 6 fields. Now the output should contain 3 fields from the file 1 and 3 fields from the file 2.
Fields in File 1 and 2
name
address
city
state
phone
Now in my output I would like to see name, address,city from file 1 and state, phone, email from file 2. Is there a way we can achieve this ?
Thank you.
Re: Join Stage
so you have any key for join or not?pp wrote: Now in my output I would like to see name, address,city from file 1 and state, phone, email from file 2. Is there a way we can achieve this ?
Thank you.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 25
- Joined: Fri Jan 11, 2008 12:49 am
- Location: Pune, India
-
- Participant
- Posts: 21
- Joined: Thu Oct 04, 2007 4:34 am
- Location: India
- Contact:
The simplest wayt to do is send one of the data thru a cpy stage and rename the field for eg. if you are sending the File1 data then File1_<ColumnName> this apply to all the column except the key column and do a join with other file and the key column should be partioned and sorted and select only the column, you required in the mapping tab. This will work only if join is a inner join.