topic Re: Mapping a file dynamically in Talend Studio

Mapping a file dynamically

Anonymous — Mon, 13 Feb 2017 04:42:26 GMT

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.

Re: Mapping a file dynamically

Anonymous — Mon, 13 Feb 2017 08:14:00 GMT

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

Re: Mapping a file dynamically

Anonymous — Mon, 13 Feb 2017 08:42:33 GMT

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.

Re: Mapping a file dynamically

Anonymous — Tue, 14 Feb 2017 07:28:51 GMT

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