i have value as
parm5 parm9 parm13
Mar-18 Sep-17 Dec-17
How to replace like this
here the mar-18 will be replaced as FY18E
sep-17 to Sep17E
Dec-17 to CY18E
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.
Please help with two things -
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables