Load CSV to Postgres: foreign key table

[Anonymous]

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!

[Anonymous]

@manodwhb 

Ok! Some way I import the job and run it. But uid_rule_group in tLogRow3 sholud be 1,2,3,4 and not 4,4,4,

4.

Thank you for your help!!