Multiple File Input with multiple sheets

[pchong]

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.

Any guidance would be much appreciated.

Thank you.

[PangHC]

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]

Dear @pchong 

this is my solution from me:

1. put the file in one directory

2. please put "directory tool" in workflow

 

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

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

[pchong]

@PangHC 
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]

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 :

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

Can you please advise?

Thank you.

[Ar13f]

Dear @pchong 

In file specification column please fill in : *.*

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

[pchong]

Hi @Ar13f 

I got the same error.

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

Thanks.

[Ar13f]

Dear @pchong 

yes that right ...

[Ar13f]

Dear @pchong 

please find attachment