I have a procses where I need to produce multiple Excel file outputs that come from a Database Table.
The table has a category column which has multiple values such as "spoc" and "Mers". I want to split out the files by this category value (one file for Spoc, one for Mers, etc). I am able to do this with a batch macro.
HOWEVER: The spoc file should only contain 4 of the fields from the data-table (which has 10 fields) and the MERS file should contain 7 of the 10 fields. This information on which file should contain which columns is found in another data-base mapping table. It looks like follows.
Group Category Columns to Output:
Is there a way that I can take an input stream (a read from the entire table) and then select the 7 columns from MERS and the 4 columns from Spoc dynamically without having to manually manipulate the select tool for each grouping. My actual table has 1000+ groupings and having to create a select tool for each is just not a realistic expectation.
Let me know if my question isn't clear enough! thanks!