Full Outer of 3 files...

kaps · Post by **kaps** » Thu Dec 29, 2011 10:02 am

I am wondering if there is another way of doing full outer between 3 or more files. Now, I use join stage to join two files and the output will be joined to the 3rd file. Is there a better way ?

chulett · Post by **chulett** » Thu Dec 29, 2011 10:04 am

Nope... at least not that I'm aware of.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 29, 2011 4:55 pm

Join stage does support more than two inputs (though the joins are still done pairwise under the covers).

kaps · Post by **kaps** » Fri Dec 30, 2011 9:32 am

Ray - Yes. Join stage does support more than 2 inputs but we can't do full outer join between all the inputs.

pandeesh · Post by **pandeesh** » Fri Dec 30, 2011 1:07 pm

kaps wrote:Ray - Yes. Join stage does support more than 2 inputs

yes,only inner join we can.

jwiles · Post by **jwiles** » Sat Dec 31, 2011 2:15 am

Inner Join, Left Outer and Right Outer support more than 2 inputs. Full Outer supports only 2 inputs.

The method you are using to do your full outer join between all of your inputs is the correct method (using multiple joins).

Regards,