How to combine few selected columns of two excel files in to another excel files

[Anonymous]

Hi,

Excel File 1: Name  Score

                    ABC      12

                    XYZ .     20

Excel File 2: Age

                     26

                     30

My new Excel file should be like 

Excel File 3 Name  Age

                   ABC     26

                   XYZ      20

Both input files are different from each other with different schema, but same number of rows.

I want to have two different columns in one file. Can this be possible? How to implement this? Can anyone help me out?

Thanks,

Meghana.

[TRF · Accepted solution]

Use Numeric.sequence to add a sequential number for each input flow then join them using this field as the key

[TRF]

Did this help?

If so, thanks to mark your case as solved (Kudos also accepted as a bonus).