Passing Multiple Tabs into Dynamic Input

Hi,

I am trying to read a file with with multiple tabs via Dynamic Input. The issue is it has tabs with different names and I only need to pick the one with Report* i.e. Report1, Report2, Report 3.

I used a formula tool to append the Tab name before passing the value to Dynamic Input but unsure how to make the Dynamic Tool not just pick 1 tab but all the tabs starting with Report.

[File] + '|||Report*'

Dynamic Processing

Accepted answers

roshan_dsouza23

Amazing it worked !

All comments

Qiu

@roshan_dsouza23

How about a filter like Contains([Tab],"Report")?

roshan_dsouza23

Will this be in the Formula Tool or Dynamic Input?

pedrodrfaria

Hi @roshan_dsouza23

I personally do not like to use the dynamic input as a batch macro to open files is a much better solution. What kind of file are you working with?

I attached a batch macro that you would plug in instead of the dynamic input. Also added a wf example.

Pedro.

Passing Multiple Tabs into Dynamic Input.yxzp

roshan_dsouza23

MultiTab lookup.PNG Working with .xls however I first need to do a Dynamic path derivation followed by looking up multiple files in a directory and then under the multiple files multiple tabs.

I have done the first 2 bits i.e. Dynamic path derivation and Lookup all files , however seems like Dynamic Input doesn't have the flexibility of recursively reading through multiple tabs in each of the files.

FYI - i couldn't open your workflow as there is some version mismatch . I am on 2019.4

SeanAdams

hey @roshan_dsouza23

2 quick tips:

a) In your main workflow you do all the work to find the file-path - then you can pass the file-path into a macro using a control parameter.

- Within that batch macro - you can then use the control-parameter to change the filename on an input tool

- and set that input-tool to return sheet names rather than data on a particular tab

- Formula tool to append sheet name onto file name

- then a dynamic input to read from the file.

b) if you ever have the error that a workflow was done on a newer version of Alteryx - just open up the Alteryx workflow in Notepad, and change the version number to the version you are using, and it will work.

roshan_dsouza23

Sure.. Will give it a go.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280