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.
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.