Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Join 2 CSV files and seed the data into database table.

Dear All
I am new to Talend and infact ETL based tools. So assume that I am zero in this. \
Now my problem is I have 2 csv files which I need to merge based on the zipcode and dump the records into database table. I am using postgres. So can somebody help me by explaining step by step procedure on how to do this?
In case if you any tutorials available share that links so that I will manage on my own.
Thanks & Best Regards,
Koundinya
Labels (3)
3 Replies
Anonymous
Not applicable
Author

Hi, koundinya75
For your requirement, i have designed a demo job for you.
File 1
zipcode;
34902OP;
39876ME;
File 2
zipcode;
98520;
98731;
The workflow is tFileinputdelimited(File1)-->tUnite-->tMysqloutput-->tLogRow
tFileinputdelimited(File2)-->
I have used MySQL DB instead of postgres DB, because i don' have postgres DB.
see my screenshots for details
For a talend new user, it recommend those following references should be read for you:
1. TalendOpenStudioforDataIntegrationUserGuide
2. TalendTutorials
In addition that , Talend has a help platform Talend Help Center provides a structured source of enriched information and knowledge, certified by Talend, where you can quickly and easily find out how to make best use of the full range of Talend products.
Hope it will help you.
Best regards
Sabrina
0683p000009MDaw.png 0683p000009MDZz.png
Anonymous
Not applicable
Author

hi all,
if your 2 csv file has the same structure, you can merge data as xdshi said.
but in other cas you could use the tMap component, and join with inner or outer join. You can also catch the rejected data if you need.
Have a look at documentation that xdshi has mentionned.
regards
laurent
0683p000009MDb6.jpg 0683p000009MDQR.jpg
Anonymous
Not applicable
Author

Hi,
@kzone, thanks for your professional answer, it's more carefulness and impressive.
@koundinya75, hope all the info involved can help you. Don't hesitate post your issue on forum, you are welcome in all time.
Best regards
Sabrina