topic how to insert in more than one table at the same time? in Talend Studio

how to insert in more than one table at the same time?

Anonymous — Tue, 20 Feb 2018 20:48:31 GMT

Hi!

I need to retrieve some rows from an excel sheet and put the information in two diferent tables.

In my excel sheet I have 4 columns (client, project, begining, end), so the first two columns will go to table project(id_project, fk_client,project_name...) and the other two (begin,end) to project_duration (id_project, begin, end).

My idea was to create a view in the database to get the max ID from project to insert into the duration table.I runned the job and all data was passed to both table, but id_project didn't go to project_duration.

Can anyone help me with a better solution? Thanks!

Re: how to insert in more than one table at the same time?

TRF — Tue, 20 Feb 2018 22:02:23 GMT

Hi,
The reason is that lookup tables or views are queried before the Excel file and before the rows are inserted in the target tables.
In this case you have to insert content into the master table 1rst, then on the next subjob you can go with the views and insert content into the child table.
Hope this helps.

Re: how to insert in more than one table at the same time?

Anonymous — Wed, 21 Feb 2018 02:57:15 GMT

if you want to insert max ID of Project into Duration, its pretty obvious you need to load Project table first. In sub job, load duration table from view (giving you max id)

Re: how to insert in more than one table at the same time?

TRF — Fri, 23 Feb 2018 08:05:06 GMT

@isadoralmeida06, did it help you?

In this case thank's to mark this case as resolved (Kudos also accepted).

Re: how to insert in more than one table at the same time?

Anonymous — Fri, 06 Apr 2018 14:25:55 GMT

That's what I was doing it, like I said on the post, that's the ideia I had as shown on the PNG I attached, but it was still putting the wrong ids. Anyways, I got it fixed.

Thanks!