You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-02-20 07:15:50

sunny.sehgal04
Member
9 posts

sunny.sehgal04 said:

Problem performing join

Hello folks i need to perform a join on 3 files based upon the year so content of my files are as follows
file : Literacy_rate.csv             
Year   Literacy_Rate
2005    11.22
2006    12.45
2007    12.04
2008    10.97
2009    12.11
2010    14.10
2011    9.9
2012    10.6

file: Graduation_rate.csv
Year    Grad_Rate
2005    65.19
2006    72.10
2007    72.2
2008    79.02
2009   77.11
2010   75.21
2011   69.22
2012   70.11

file 3 :grad_count.csv
Year  Grad_count
2011  77
2012  79
2013  67


Now  when i perform join i don't get year 2013's data as both the file i.e Litearcy_rate.csv and Graduation_rate.csv doesn't contain 2013  year . Can you please provide me any solution for this problem Urgently.
I Need final output as:
Year   Litearcy_Rate     Grad_Rate     Grad_count
                                         

Offline

#2 2017-02-20 17:43:58

PraveenKS30
Member
4 posts

PraveenKS30 said:

Re: Problem performing join

It's not going to work with simple joins. You have to work on the idea of the right outer join.

My Job:

mini_Job_design.png_20170220-0844.png

Output :

mini_Output.png_20170220-0845.png

Last edited by PraveenKS30 (2017-02-20 17:45:54)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy