Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Filter Multiple excel tabs at the same time

ZahinOsman
8 - Asteroid

Hi Guys,

 

I'm trying to filter a few excel tabs at the same time (same data type/schema), but my workflow is throwing up an error. To provide context;

 

I have an excel sheet with several tabs below + sheet 1. Previously, these excel tabs were all in separate excel files but I have combined them into one excel sheet.

 

Exceltabs.JPG

 

I want to filter all the tabs excluding Sheet1 at the same time using the following column (eventinitiatinguserid)

 

Filter.JPG

 

However, I'm getting an error below where the workflow cant find the file. 

 

Workflow.JPG

ErrorLink: Dynamic Input (9): https://community.alteryx.com/t5/*/*/ta-p/733391?utm_source=designer&utm_medium=resultsgrid|Can't find the file: "C:\Users\X01381862\Desktop\Nicole Alteryx\CombinedFiles.xlsx|||C__Users_X01381862_Desktop_Nicole Alteryx_CombinedFiles.xlsx|||<List of Sheet Names>". Make sure the file path is correct.

 

I have attached my current work in progress workflow. It seems its trying to read a concatenated version of the combined file, how do i get around this?

 

 

 

1 REPLY 1
binuacs
21 - Polaris

@ZahinOsman you need to replace the <List of Sheet Names> with the original sheet name. sample workflow attached

image.png

Labels
Top Solution Authors