how to do left join in transformer
Moderators: chulett, rschirm, roy
how to do left join in transformer
all,
how to do left join or left outer join in transformer?
thanks in advance
how to do left join or left outer join in transformer?
thanks in advance
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Jessie,Jessie wrote: each of the 3 files has some rows that cannot be joined with, and I want all the row from all the 3 files. how to do it?
thanks
According to my understanding of your problem, why don't you use the Merge stage to join the files. If you need to get the data from 3 files, Use merge stage to combine two files into one and then, may be use another merge stage (in a separate job, of course) and combine the files? Is there a specific reason why you are creating Hash files or is it for this joining purpose itself?
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Jessie,Jessie wrote: the out put file from 'merge, has file1.key, file2.key
how do I join them to make it one row?
thanks
The way you join is, say, File1.Key and File2.Key need to be joined, in the Outputs page, under Mapping tab, you drag and drop the same in the specified areas where it says "Drag From File Column Names to populate map keys".
Please note that you specify the kind of join you require in the Output page\General Tab.
These steps combined with populating all the other fields in the Outputs page correctly should do the trick . I have not used Merge stage as much, but it should work fine. Also, please do refer to the documentation on Merge stage provided along with the tool.
Hope this helps...
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: how to do left join in transformer
A lookup from a server Transformer stage is inherently a left outer join; it returns null for all columns on the reference link if the lookup does not succeed.Jessie wrote:how to do left join or left outer join in transformer?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.