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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema