New Sheet Name Every Month in the Source File

[surajmthomas]

I have an Excel Binary File which is downloaded from the System every month. Each file contains only one Sheet and the Sheet Name varies month on month. For example 

FILE #	Sheet Name in April	Sheet Name in May
File 1	903017	962135
File 2	874564	845752
File 3 .... and so on

When I built the workflow, I built it using the April Files loading April Sheet Names and it works well.

Now when I replace the source folder with the May files, the May Sheet names are different from the April ones as depicted in the above table and therefore the Input Tool does not read them.

How to I force the Input Tool to read the only sheet available in each of the files irrespective of the changing sheet names.

[mceleavey]

@surajmthomas ,

Can you provide more details as this is designed to do exactly what you're after. I'm interested to see the problem.

M.

[surajmthomas]

mceleavey I have attached the steps that I perform. Hope this would explain it better. I have explained it with 1 example. I have multiple Files that I work with in the same manner and it is called at different points in my workflow. It is tedious to go every month and keep changing the source file at different points in the workflow so that the changed sheet name is pulled in via the Input tool.

[mceleavey]

@surajmthomas ,

So in my previous post, the first tool reads in every file and their sheet names. This makes it dynamic, picking up every sheet name regardless of naming convention, and every new file will be picked up. It then joins this to the fullpath of the file and then loads them all in. Then you can do what you want with them. I don't see the problem.

What was the error you received?

M.

[surajmthomas]

mceleavey Grateful if you could help as to where I am going wrong. I tried to figure it out but, I end up in a mess. I am unable to attach a .xlsb file. Therefore I have attached the .xlsx version of the source file that I receive every month. Under my work circumstances, I get only the .xlsb versions as source files

[mceleavey · Accepted solution]

Hi @surajmthomas ,

I don't understand. It works perfectly for me.

Replace that second tool with the xlsb tool attached and change the directory tool accordingly.

M.