Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Read in Multiple Sheets from one File with Same Schema.

DataPirate26
10 - Fireball

Hi, 

 

Can someone help me with this workflow. I want to read in Multiple sheets from one file having same Schema and structure using a dynamic input tool. It is throwing me an error. Can someone assist me to resolve this problem. I have attached the workflow below. 

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@DataPirate26 
If you could post the error message, we may be more specifiic.
I tried with some dummy data and the flow works on my side.

  • When select the flle, make choose the "Import list" option
  • The sample file shall be accessible.0228-DataPirate26-1.PNG0228-DataPirate26-2.PNG
DataPirate26
10 - Fireball

@Qiu . Hi Maybe somewhere I am doing a mistake in the Action tool. Not able to open the workflow that you have sent. Can you tell me in the File browse tool do we need to select the sheet or we need to select on import the List of Sheet names. Normally when running in .yxmd format it is working fine. In app mode it is throwing error. 

Qiu
21 - Polaris
21 - Polaris

@DataPirate26 
we need to select Import the List of Sheet names

DataPirate26
10 - Fireball

@Qiu It worked fine . Thank you 

Qiu
21 - Polaris
21 - Polaris

@DataPirate26 

Good to know it is working now. and thank you for the accept mark. 😁

Labels