Import Excel Sheet where name slightly changes

Hi All,

I'm trying to configure my input tool to use a wildcard in the Sheet name. The file name will be static but the Sheet Name with be some variation of "Export-*" (Export-1,Export-2,Export-3,etc.). I can't seem to find how to do this in the normal Input Data tool.

Input

Accepted answers

gautiergodard

@LoganDougherty Try this.

You just have to import the packages.

Basically you'll want to use the input tool to bring in the sheet names of your workbook, using those sheet names and a formula construct a full path, and then pass that path into the dynamic input tool.

import.yxmd

All comments

gautiergodard

Hey @LoganDougherty

You could try something a bit more dynamic, like this:

import.yxzp

Luke_C

Hi @LoganDougherty

The following thread should help, typically the dynamic input or batch macro approaches work best here.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-dynamic-sheet-name/td-p/746247

LoganDougherty

I dont think my firm has the newest version of alteryx available because I cant download your solution. Would you mind showing me how you have the dynamic input configured?

gautiergodard

@LoganDougherty Try this.

You just have to import the packages.

import.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280