I have module that takes a variety of different tables (different column names) strips this down to the Key and Tags columns, does a split text to rows and then writes to out to a DB based on parameters sent to the module
I was able to do this once with a SANDBOX, but now I want to remove the sandbox before the SELECT-COLUMNS so that this module can be shared by many other module invokers.
the issue I have is it now complains about missing columns
I could try hacking around with the Input and Create Column transforms, and I bet your would appreciate this so that I was not bothering you so much in the forum. But I suspect this is a pattern that others might come across, so it might be useful to store as a forum question.
Here is the same module with an INPUT transform at the front: