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.
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.
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
@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.
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.
Dear @pchong
In file specification column please fill in : *.*
and in "dynamic input" please make sure sheet and column naming must be the same
Hi @Ar13f
I got the same error.
I should pick the sheet that I want on "dynamic input" right?
Thanks.