Join Stage

[pp]

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.

[swades]

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.

so you have any key for join or not?

[pp]

yes I have one field as key.

[ray.wurlod]

Then simply specify that field as the join key, and make sure that you partition and sort on that field.

[DSRajesh]

Hi Ray,

How join supports 2 outputs here?

is it required to use any other stage with join?

Regards

[dhanashreepanse]

Rajesh,

Based on the joining key, Join stage can take the required columns from both the input files.
On the output -->mapping tab, you can specify the required mappings.

-Dhanashree

[sureshabbisetti]

Hi
Use Copy stage after join stage. In each output link select only the required columns.

[krisna]

As suresh said, using of Copy stage after join stage is working fine

[Prabhakar]

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.