Dynamic Input from "Excel Sheet Name with Blank"
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to input "Multi Excel Multi Sheet" at once and almost completed.
(with many thanks for https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Input-Multiple-Sheets-from-Multiple-E...)
However, I realized some sheet include BLANK in end of their sheet name(for example, "Sheet1 ")
If I prepare master "Sheet1 ", dynamic input meet error.
I'm searching solution for this for long time but I can't find....
Could you kindly help me about this? I attached Sample flow for this.
In Macro Icon, Dynamic Input icon is my forcus point.
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Becky I added a formula tool in your macro in order to add quotes to handle spaces:
"'"+[Sheet Names]+"'"
I also changed your action tool to just replace the file name and leave the bogus sheet name that gets replaced by the sheet name coming in.
It seems to work now on my end!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much!
Sorry, I still in confirming so I will reply here later, Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! Finally, I got result what I want!
Sorry for my late reply, thanks!
