Pulling in Multiple Excel workbooks with different Sheet names

[guystanley]

Hi, sorry for what is probably a basic question, but I'm a new user and haven't been able to find a solution in the Community. I have a directory with ~30 Excel files that I want to combine into one, where each file follows the same naming convention but with different date prefixes.  Not wanting to have 30 input tools, I am trying to use a single Input tool with a wildcard.  I am having 2 resultsing issues.

1 - each workbook usually contains 2-3 sheets; and the one containing the data I want never follows a consistent naming convention, but it usually contains the text "230".  Doesn't seem like there is a wildcard option for sheet name, does anyone have any other suggestions?

2 - the relevant fields in the worksheet are always included, but are not always in the same column order.  using an Input tool with a wildcard does not seem to have the capability to re-order & marry up the fields the way a Union tool does.  is there a better way to do this?

any help greatly appreciated

Guy

[dmuseve]

Hi Jordan,

This is a simple question but I have not been able to figure this out. How do I delete the "|||<List of sheet Names>" part so that its not displayed in the action tool

[JordanB]

You need to select the 'replace a specific string' tick box at the bottom of the action tool configuration window. You will then be able to select the part of the text you want to replace

Best,

Jordan

[akhalid028]

Hi Jordan - I am applying after making changes but the changes won't apply. Can you help me out please ?

[JordanB]

@akhalid028 

Can you send a screenshot of the current configuration you have?

Best,

Jordan