topic Re: Load CSV to Postgres: foreign key table in Talend Studio

Load CSV to Postgres: foreign key table

Anonymous — Sat, 16 Nov 2024 06:31:34 GMT

Hi,

I have a csv file to load in several Postgres' tables. I loaded data on the first two table and then I want to fill up the third one. To do that, I need the primary key from table1 and table2. I attached myJob and my tMap2 where I am doing a lookup with the first two table filled.

The problem is that the result is always 0 for fk1 (row5.uid_policy) and fk2 (row3.uid_rule_group). How can I solve it? Thank you in advance!

Re: Load CSV to Postgres: foreign key table

Anonymous — Thu, 21 Feb 2019 17:08:42 GMT

Hi,

In your tMap, I am not able to see any join conditions (sample as shown below)

You will have to select inner join between Main table and two lookup tables based on columns which are present in both tables. Could you please change it and verify it? If you are still facing problem, please share a sample file for both main table and lookup with columns to join and I can show it from Studio.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Load CSV to Postgres: foreign key table

Anonymous — Fri, 22 Feb 2019 08:52:52 GMT

You're right!! I completly forgot to set the join condition!!

I see the values now, but I have one more problem: my table "rem_v_rule_group" has the following values (example):

uid val

1 COMPLETED

2 COMPLETED

3 COMPLETED

4 COMPLETED

5 COMPLETED

val assume always the same value. Just uid, as primary key, is different. When I use the join condition in tMap2, on val, the value returned is always 24...the last uid in my table. I also tried to modify the join condition (All Matches, Inner Join), but I got 574 values in return instead of 24.

Re: Load CSV to Postgres: foreign key table

Anonymous — Fri, 22 Feb 2019 09:03:14 GMT

Hi,

I am slightly confused here!

If you are joining on a key and the join is resulting in multiple matched records, it will take the unique match based on last record of lookup. So it is working as expected. If you want to get all match combinations, you will have to select All Match and it will give all combinations based on match.

Could you please explain what you are trying to achieve here by join? Please share sample input files for tMap, expected output data and the data you are getting for this tMap. Then we should be able to help you better 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂