Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
I am trying to figure out how to select columns based on whether they appear in a list (which I have built elsewhere in my macro). This will be dynamic as part of a macro that reads in multiple Excel files and outputs selected columns to a DB table.
Is this possible? Dynamic Select doesn't have multiple inputs so I don't see how I can use that; I can't see the right way to combine my two inputs together to get the output I need.
So I have input tool (Excel source) and input tool (a list of columns) plus some data processing steps, and I need to get to an Output tool to a database where the output is the Excel file but only the columns I need.