Mapping a file dynamically

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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