Dynamic Input from "Excel Sheet Name with Blank"

[Becky]

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!

[patrick_digan · Accepted solution]

@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!

[Becky]

Thank you very much!

Sorry, I still in confirming so I will reply here later, Thanks!

[Becky]

Thanks! Finally, I got result what I want!

Sorry for my late reply, thanks!