You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-08-22 12:57:00

SDaria
Member
2 posts

SDaria said:

[resolved] import values to mutivalue element set as "foreign key"

Hi, i'm have entity with mutivalue element set as "foreign key". 
I want to import values to this element from mssql table to get data like

Entity1
Name
Entity2Id_1
Entity2Id_2
Entity2Id_3

So i created this mssql tables
Table 1
id_t1
Name_t2

Table 2
id_t2
Name_t2

Table_3
id
id_t1
id_t2

and 2 entity

Entity1Id (string)
Name_1 (string)
Entity2Id (string) 0...many FK Entity2Id

Entity2Id (string)
Name_2 (string)

and joining table_1 and table_3 to insert data in job. But in mdm i can see only one last value. 
Entity1
Name
Entity2Id_3
How it should be done?

UPD. Found solution.

Last edited by SDaria (2016-10-25 09:08:23)

Offline

#2 2016-08-23 13:50:35

JerryOne
Member
3 posts

JerryOne said:

Re: [resolved] import values to mutivalue element set as "foreign key"

Hello SDaria,

Can you elaborate your queasiness in more details so we can provide you best solution for that.

Regards,
Jerry 

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy