Skip to main content

I am looking to have a workspace run by a workspace runner to parse out some data to be grouped by individual tabs based on an attribute name.

i have an excel workbook with a dozen or so sheets, each sheet is a type of mechanical system with 3 columns - Column A is BLD which is a string building name. Column B is System Type which had data validation in place with named table references and Column C is System Name which is a string value.

i am using a feature reader with the read formulas checked:


i want to have the workspace runner pass a value for BLD and search all of the sheets for matches - for instance, it looks something like this once run:
 

 

The workspace is finished, except for the writer - i want to create a new workbook for each unique BLD feature and copy from an excel template that has the existing named ranges for the various data validation lists from the original read file - however, i can’t get the validation to copy, nor the sheet with the named ranges.

my writer is set up like this currently:

i am unsure how to not have to recreate the data validation from the original sheet?

Be the first to reply!

Reply