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 -
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.