Mapping a file dynamically

One Star

Mapping a file dynamically

I have a input file which has columns A_min,A_max,A_avg,B_min,B_max,B_avg............Z_min,Z_max,Z_av, i want to map  this file to into another file, which will have columns, min,max,avg. 
Mapping of this job would be like
A_min,B_min,C_Min...Z_min will map into column min.
A_max,B_max,C_Max...Z_max will map into column max.
A_avg,B_avg,C_avg...Z_avg will map into column avg.
so on.
Moderator

Re: Mapping a file dynamically

Hi,
Please take a look at a component tMap which can transform and route your columns on demand.
Here is the component reference:TalendHelpCenter:tMap
Let us know if it is Ok with you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Mapping a file dynamically

I am sorry, but i cant accomplished what i want to do.
tmap doesn't allow us to  map two fields into one field. 
please give some more hints.Smiley SadSmiley Sad
Moderator

Re: Mapping a file dynamically

Hi,
tmap doesn't allow us to  map two fields into one field.

Could you please show us your current job setting screenshot? In this way, we can see if there is any wrong setting on your end.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.