Talend community forum / tXmlMap

peterm · 2012-06-01 13:57:32

I have a dataset that I need to transform in order to push it up to salesforce and was wondering you could please provide an example. What I need to do is take two table and pull to rows from table2 and add them as columns to the output for salesforce. The databace gives me a identifier so I will only have data with plantype ch and x but how can I flatten that info and append it before sending it on?

The dataset

Table1
--------
id name dob gender
--------------------------------

Table2
--------
id foreignkey Identigier PlanType
-------------------------------------------------

SalesForce
--------------
id name dob gender PlanTypeCH PlanTypeX
---------------------------------------------------------------------

shong · 2012-06-01 15:32:33

Hi
Can you give us an example with some real data? What's the input data? What are your expected result?

Best regards
Shong

petem · 2012-06-01 21:52:57

The dataset

Table1
--------
id name dob gender
---------------------------------
1 petem 1/1/1950 m

Table2
--------
id foreignkey Identigier PlanType
-------------------------------------------------
1 1 Test1 CH
2 1 Test2 x

SalesForce
--------------
id name dob gender PlanTypeCH PlanTypeX
---------------------------------------------------------------------
1 petem 1/1/1950 m Test1 Test2

gusto2 · 2012-06-03 15:30:46

Hi Petem,

as far I understood your needs you can use a tMap or tXMLMap component to lookup values from other tables (example: http://www.talendforge.org/tutorials/tu … p?idTuto=9 ), one input is master (with reference data) and other inputs are lookups based on a foreign key.

Gabriel

Last edited by gusto2 (2012-06-03 15:32:50)

Announcement

Unanswered posts

#1 2012-06-01 13:57:32

tXmlMap

#2 2012-06-01 15:32:33

Re: tXmlMap

#3 2012-06-01 21:52:57

Re: tXmlMap

#4 2012-06-03 15:30:46

Re: tXmlMap

Board footer