topic Re: Save files name and content in two table in Talend Studio

Save files name and content in two table

Anonymous — Fri, 14 Apr 2017 16:10:30 GMT

Hi everyone,

I need to save many files in two tables oracle

- table parent : save filename and sysdate

- table child : save content file + PK of parent table

Thank you in advance

Re: Save files name and content in two table

TRF — Fri, 14 Apr 2017 16:12:09 GMT

And your question is?

Re: Save files name and content in two table

Anonymous — Fri, 14 Apr 2017 16:23:44 GMT

Now I can save in the parent table, but not correct in the child table.

Do you have an idea please.

thanks.

Re: Save files name and content in two table

cterenzi — Fri, 14 Apr 2017 17:44:30 GMT

I would recommend you use OnSubjobOk instead of OnComponentOk on the connection to tOracleInput_1.

If the purpose of tOracleInput_1 is to retrieve the records from the parent table in order to provide the keys for the insert into the child table, you probably want to make that flow your lookup and the flow from your tFileInputPositional the main. Beyond that, we'll need more details about the problem you are experiencing. Are you getting an error message? Is the job finishing but not writing the expected information to one or both of your tables?

Re: Save files name and content in two table

Anonymous — Mon, 17 Apr 2017 08:02:39 GMT

Hi,

What's the error you are getting for your subjob 2(child)?

Here is a KB article about:https://help.talend.com/pages/viewpage.action?pageId=190513190

Hope it will be helpful.

Best regards

Sabrina

Re: Save files name and content in two table

Anonymous — Tue, 18 Apr 2017 17:23:49 GMT

Thanks for your replies. I have no errors in my job, but i have the same contents in my two child tables.

File 1

name : file1.txt

content :

100Name

200Country

300ADRESS

File 2

name : file2.txt

content :

400Name

500Country

600ADRESS

In my table, Parent, i have two records, file1.txt and file2.txt, => correct

But in my tables : child 1 and child 2 i have the same contents.

Re: Save files name and content in two table

cterenzi — Tue, 18 Apr 2017 17:48:06 GMT

If your job design is the same as your screenshot on 4-14, you're not going to get the results you expect. If you are iterating over a list of files, those should be the main flow in your tMap, and the query from the database should be the lookup.

Re: Save files name and content in two table

Anonymous — Wed, 19 Apr 2017 12:25:39 GMT

i changed the main flow in tMap, and the query from the database in lookup.

now i get the contents two files in the same table 1.

Re: Save files name and content in two table

vardhane — Thu, 28 Dec 2017 08:47:03 GMT

Hi, We have a similar scenario. We are using MySql. We want to loop through the files in directory and insert the filename and sysdate in first table which is having auto increment ID column. The newly inserted filename ID has to be taken to another table along with the content of the file.

PFA ,Currently we could load the data into main table wiithout the fileid from first table.

Can someone please help us, using which component we can achieve our requirement.

Table1

FILENAME

SYSDATE

Table2

FILEID(ID column from Table1)

CLI

EST ...

Thanks in advance!

billing.PNG

Re: Save files name and content in two table

Anonymous — Wed, 18 Mar 2020 13:55:51 GMT

I also looked for a solution but could not get an answer anywhere. Maybe this is wrong, but I did so. In tMap, I created a stream with a file name and identifier. On the way to the database with a table of file names, I added an aggregator with the key file name and with the aggregation function of only the first record.