topic Re: Integrate two tHashOutputs and merge into one tHashInput in Talend Studio

Integrate two tHashOutputs and merge into one tHashInput

synfield — Thu, 10 Sep 2015 07:58:03 GMT

Hi,
I'm wanting to take contents of two tHashOutput and merge into one thashInput, I've logged there output to the console as follows;
.-----------------------------------------------------------------------.
| tLogRow_4 |
|=---------------------------------------------------------------------=|
|error |
|=---------------------------------------------------------------------=|
|FIELD_CUSTOM_VALIDATION_EXCEPTION:Cannot be blank.:BillingPostalCode --|
|FIELD_CUSTOM_VALIDATION_EXCEPTION:Cannot be blank.:BillingPostalCode --|
|FIELD_CUSTOM_VALIDATION_EXCEPTION:Cannot be blank.:BillingCountry -- |
|FIELD_CUSTOM_VALIDATION_EXCEPTION:Cannot be blank.:BillingPostalCode --|
'-----------------------------------------------------------------------'
.--------------+---------+------------------+-----------------------+-------------+-------------.
| tLogRow_7 |
|=-------------+---------+------------------+-----------------------+-------------+------------=|
|StatusCodeResp|smsId |crmId |crmAccName |errorRespMesg|timeStamp |
|=-------------+---------+------------------+-----------------------+-------------+------------=|
|200 |150017720|001O000000lttjbIAA|Davis Wiremu Humphreys | |1441846527149|
|200 |150017726|001O000000ltggSIAQ|Daniel Josiah Humphreys| |1441846530300|
|200 |150017728|001O000000lt4eLIAQ|Henry Jones | |1441846531192|
|200 |150017729|001O000000lttl8IAA|Michael Andrew Tito | |1441846531707|
'--------------+---------+------------------+-----------------------+-------------+-------------'
I need to put the contents of tlogRow_4 into the "errorRespMesg" column of tLogRow_7, in the order that they are presented.
Thanks,
Synfield.

Re: Integrate two tHashOutputs and merge into one tHashInput

Anonymous — Thu, 10 Sep 2015 09:23:00 GMT

A tMap would help you with this, but you seem to be missing a key on the tLogRow4 side. If you can control the order, then you could add a numeric column to both and use that for a simple inner join within the tMap.

Re: Integrate two tHashOutputs and merge into one tHashInput

Anonymous — Thu, 10 Sep 2015 12:16:38 GMT

Hi
To merge two data flow from different data source, you can use tUnite Component. You may need to unite column name before merging the data.
Best regards
Shong

Re: Integrate two tHashOutputs and merge into one tHashInput

Anonymous — Fri, 11 Sep 2015 00:00:15 GMT

That was not the question Shong. They want to join the two data sets to result in 4 rows, not union the two datasets.

Re: Integrate two tHashOutputs and merge into one tHashInput

synfield — Fri, 11 Sep 2015 00:30:50 GMT

Thanks, Shong and rhall_2.0.
Yes I was using tmap and thought about adding id columns in the two input schemas, but couldn't get the increment expression to work in tmap for these two inputs.
I'm only able to add an expression in the 'lookup' schema input.
I tried using "Numeric.sequence("s1",1,1)", but couldn't get it to work.
What is the best way to achive this?
Thanks.

Re: Integrate two tHashOutputs and merge into one tHashInput

synfield — Fri, 11 Sep 2015 01:43:12 GMT

I've Manged to solve it, but not sure if this is the most efficient way?

Re: Integrate two tHashOutputs and merge into one tHashInput

Anonymous — Fri, 11 Sep 2015 02:12:14 GMT

Understand your question right now, as rhall_2.0 suggested, you achieve it in the right way .