Import Excel Files of Wanted Schemas

[Grub]

There seems to be much information on importing Excel files of different schemas.  I, however, require a twist on this that I cannot seem to find.  I have the following situation:

• Multiple Excel files with an unknown number of schemas (all on the 1st tab but with different tab names)
• I only want to import and process the 3 schemas that I have set up in my workflow. (This is the twist I cannot solve)
• The remaining schemas(files) - if any exist - should be gracefully handled at the file level.  I do not have to or want to process them right away.  I just need a filename(s) in a separate path so I know which they are and add them to the workflow.
• Each filename is different in the folder
• I am using a batch macro to bring the various schemas into one path, but if there is a better way...

Thanks all.

[pdave87]

Hi,

Excellent situation, is it possible to share the workflow/3 schemas that is required in your use case? I want to take a look.

Regards,

Pratik

[Grub]

I have attached the beginning of my workflow that opens the files.  I have also attached the 3 files with the different acceptable schemas.  I think I have found a work around with a Multi-row tool and filters.  Let me know if there is a better way.

Thanks.

[Grub]

While I was looking to handle this with the Input Tool, I found a work-around.

Bring everything in whether I want it or not.  Then with the multi-row tool I group by file (1 schema per file) look for the starts of the schemas I have specified and add a column to put in a 1,2, or 3 depending on which schema it is.  I then use filter tools send schema 1 through 1 path, schema 2 through another and schema 3 through another.  Any file that didn't have a schema number gets dropped.

I think looking at the entire schema format from the Input Tool or the like would be more definite, so if anyone has any ideas let me know.  Otherwise, I will give my method a try.