Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Darmesh
Contributor III
Contributor III

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

Labels (2)
2 Replies
David_Beaty
Specialist
Specialist

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

iamabhishek
Creator III
Creator III

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