Dynamic Input cannot see existing tab

[Kinga]

Hi,

I have strange issue. I had to use data from multiply Excel files from the same tab named "Data_". when I'm using the standard Input Tool Alteryx could find this tab and I can use data. However, when I'm using Dynamic Input Tool I have an error that this tab does not exist. I tried also check, if it is all the tabs, but other I checked (e.g. tab "FX_" are used normally) Please find below:

   

Could you help me understand how could I fix it?

Thanks in advance,

Kinga

[Felipe_Ribeir0]

Hi @Kinga 

1)What is the result of the formula Fullpath2? It is Foldername\Filename.xlsx|||Data_?

2)Can you share the configuration inside your Dynamic Input/Edit?

[binuacs]

@Kinga You need to filter out all the sheet names except 'Data_' then connect to the Dynamic Input tool

[Kinga]

hi @Felipe_Ribeir0 

1) Yes, this is Foldername\Filename.xlsx|||Data_.

2) 

Hi @binuacs 

I tried your solution, but it didn't work :( 

Regards,

Kinga

[binuacs]

@Kinga @The workfkow which I provided is working for you?

[Kinga]

@binuacs, yes your workflow worked, but when I tried to use my file, it wasn't work :(

I found solution myself: small batch macro which is updating file name for standard Input Tool. Theoretically doing the same as Dynamic Input (or even less), but it is working, and Dynamic Input Tool not.

Thank you, guys, for support. I someone want to still think about it, I could check proposed solutions on my file :) But it is not needed now.

Regards,

Kinga