Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiple File Input with multiple sheets

pchong
8 - Asteroid

I have files with different dates, each has a few sheets but same columns.

I want to do a dynamic input that combine the rows of a particular sheet (ie sheet1 of all the files)

"*" at the Input tool didn't do the trick.

pchong_0-1632099179427.png

pchong_1-1632099473351.png

 

Any guidance would be much appreciated.

Thank you.

8 REPLIES 8
Pang_Hee_Choy
12 - Quasar

you  need to use dynamic input tool.

 

it a bit tricky, but the way is:

input tool

1. Load list of sheet name instead of Sheet1

2. load full path instead of filename only.

formula tool

1. Replace the "<List of sheet name>" in [Filename] with [Sheet name]

*the name of field and text may not correct. as i do not verify.

dynamic input tool.

1. config is to change full path.

2. sample file, the setting will applied to the output.  

 

 

Ar13f
10 - Fireball

Dear @pchong 

 

this is my solution from me:

 

1. put the file in one directory

2. please put "directory tool" in workflow

 

Directory1.png 

 

3. select "dynamic input" and please 1 file to make the template

 

Directory2.png

 

you can search for these tools function in the "search" field

pchong
8 - Asteroid

@Pang_Hee_Choy 
Thanks for the reply.

Is the action supposed to be "Change File/Table Name" ?
I use Book1 (the first file as sample).

 

Somehow Alteryx Can't find the file, I have to look into that.

pchong_0-1632105268592.png

 

pchong_1-1632105305993.png

 

pchong
8 - Asteroid

Hi @Ar13f 

In the "dynamic input", I have selected my first file as sample, and the sheet that I want to append.
But there is an error saying it does not match a sheet or range :

pchong_0-1632105719959.png

 

This is what I have on the "directory". I use the wildcard * to grab all the files.

pchong_2-1632105778634.png

 

Can you please advise?

Thank you.

 

Ar13f
10 - Fireball

Dear @pchong 

 

In file specification column please fill in : *.*

 

Directory1.png

 

and in "dynamic input" please make sure sheet and column naming must be the same

 

Directory3.png

pchong
8 - Asteroid

Hi @Ar13f 

 

I got the same error.

 

pchong_0-1632107458361.png

 

I should pick the sheet that I want on "dynamic input" right?

pchong_1-1632107497614.png

 

 

Thanks.

Ar13f
10 - Fireball

Dear @pchong 

 

yes that right ...

Ar13f
10 - Fireball

Dear @pchong 

 

please find attachment

Labels