Hi guys,
I'm trying to download this excel file off the internet, but it seems like I cant use the Dynamic input for some reason. I've tried the solutions that I found on some other topic but its not working. Can someone please help me out!
Thank you 🙂
Solved! Go to Solution.
Hi linwk,
I think the issue you're having is that the size of the Filename field is too small and therefore missing the |||<List of sheet names> part. Just add a Select tool before the Formula tool and increase the size of Filename so that you're getting the correct value going into the the Dynamic Input tool.
Let me know if this works.
Thanks,
Josh
Hi @linwk,
Your Filename column is being truncated when you try to add the sheet name to it:
This happens when it reads the column in from the Text Input tool; Alteyrx auto-determines what it thinks will be the best field size for the column. To remedy this, just add a select tool and change the size to a more appropriate one:
Additionally, you need to amend your formula to the following string:
[Filename] + "|||<List of Sheet Names>"
Alteryx won't recognise "List of Sheet Names" unless "Sheet" and "Names" are in proper case.
Sam 🙂
Hi Joshua,
It works fine now. Thank you very much. Another question though, if i'm trying to get say <Table 2> in the excel file, does the same method apply? I tried doing it but now it says it does not match a sheet or named range is corrupt
Thank you for your prompt reply! Have a nice day!