topic Re: How to replace a values in tmap in Talend Studio

How to replace a values in tmap

Darmesh — Wed, 13 Jun 2018 08:45:41 GMT

i have value as

parm5 parm9 parm13
Mar-18 Sep-17 Dec-17

How to replace like this

FY18E/Sep17E/CY18E

here the mar-18 will be replaced as FY18E

sep-17 to Sep17E

Dec-17 to CY18E

Re: How to replace a values in tmap

David_Beaty — Wed, 13 Jun 2018 09:03:59 GMT

As your mapping for the incoming to outgoing seems a movable entity based on the current period/year, I'd suggest you introduce some kind of metadata/config into a hash input/output and join it in as a lookup flow.

Thanks David

Re: How to replace a values in tmap

iamabhishek — Wed, 20 Jun 2018 12:53:46 GMT

Please help with two things -

is the sample data provided a complete list for your input or you would have more
what is the logic that has been taken into account during the data transformation