Six Stars

How to replace a values in tmap

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

2 REPLIES
Seven Stars

Re: How to replace a values in tmap

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

Regards

David

Don't forget to give Kudos when an answer is helpful or the solution.
Nine Stars

Re: How to replace a values in tmap

Please help with two things - 

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