I followed the instructions on the below blog and was able to get most of my sheets to pull in from my excel file. The problem is that it will not pull in my tabs that have spaces and gives me the error message listed in the attachment. Any ideas what I add to the macro to get this to work?
https://www.concentra.co.uk/blog/how-import-multiple-excel-sheets-and-files-different-schemas-alteryx
Hi,
Looks like the first CrossTab Tool was changing 'special' characters to underscores.
How about this as a replacement?
Your macro worked for me using with various worksheet names including/excluding spaces etc. Can you provide a sample of data from Test Database.xlsx so that I can test against the original flow?
Cheers,
Iain
Sorry about that, attached the wrong file. Here is the excel file.
Can you update in my Tableau template and send back? Or provide me the formula to copy in?
See below. The formula just replaces FileName with the text up to the delimiter '|||' (they are pipe characters even though they look like slashes). The Select changes the name back to File Name (may not be necessary depending on actions later in the flow)
