I have a file1 with columns col1, col2, col3, col4,col5 with 10 rows and file2 with col1, col2, col3, col6,col7 with 5 rows. I need the output as col1,col2,col3, col4,col5 ,col6,col7 with 15 rows. How to do this ?
You need to use tJavaRow or tfiltercolumns to add all the unique columns from each flow to the other flow so that both have the same schema and then use tUnite to union them.
