Marketplace has an add-in called 'PDI Stream Schema Merge' which "Merges the schema among multiple streams. Leaves fields blank where they don't exist in the source schema."
I have tested this with a simple 2 data grid example. Datagrid 1 has 1 column of numbers. Datagrid 2 has 1 column of letters. I connect both grids to the Schema merge step and "Get Steps to Merge", which is both Datagrids. I added a Dummy step to view the results of my test. I have not been able to make this work.
Has anyone used/tried this add-in with success? What am I missing?
Is there another way to achieve this?