How to transform one table into three with foreign keys and associative entity

[Anonymous]

Hello,

I'm quite beginner with talend and i don't know how to load data from one table into three new tables (associative entity), see picture below.

Both ID's from person and coordinate are generated automatically (auto_incremented ID's) and I need to get them in order to fulfill my last table person_coordinate. I have already find and use solution about one similar case when there is only one "parent". I had to disable "extend insert" then add a rule with the expression "LAST_INSERT_ID()" but that can't be applied in my current case because I need two ID's...

Thanks,

Guillaume

[Anonymous]

Hello,

Please stick to one topic:https://community.talend.com/t5/Design-and-Development/Transform-1-table-into-3-tables-using-foreign... so that we could pay individule attention to it.

Best regards

Sabrina