bjackson-ep commented on issue #3221: URL: https://github.com/apache/hop/issues/3221#issuecomment-1817724724
[excel-different-layout-solution.zip](https://github.com/apache/hop/files/13401961/excel-different-layout-solution.zip)  There are 3 fields that go into the Excel Input Transform. The Excel file has 3 fields to output itself. Notice when you check the dummy step output shows 3 fields only from the excel file. However, if you "Show Output Fields" it shows 6 (the three from the data grid, and the three from the Excel file). It would be great to have the option of letting those incoming fields pass through, or if that is not possible, to at least remove them from the stream that comes out of the Excel File Input. As is, if you have a Select Transform, it will see A, B, C, from the datagrid and the others from the excel file, but will mess up and throw errors because somehow it does not have real access to A, B, C. Generally I like the option to either let incoming fields flow through or not. This case is a bug because it looks like the transform did not intend to let those incoming fields flow out, but let the metadata for them flow out anyway. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
