Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic Excel sheet names

JCornn
7 - Meteor

I have a workflow that gathers the file paths of Excel files in a directory, then creates a field called [SheetPath], in which the [FullPath] of every .xlsx file in the directory is combined with “|||’Sheet 1 $’”. The screenshot below is of a demo workflow that shows what I am currently doing:

JCornn_0-1628191398989.jpeg

 

What I am wondering is if it is possible for me to generalize the expression in the formula tool to allow for [SheetPath] to replace “Sheet 1” with any given sheet name (e.g. “Sheet A”, “Sheet B”, etc.)?

Note: To be clear, the screenshot above is only an example; it is not my actual workflow. Please assume that I am not able to pass the [FullPath] field from beginning to end in my actual workflow.

3 REPLIES 3
JagdeeshN
12 - Quasar
12 - Quasar

Hi @JCornn ,

 

You can possible do this by changing the file URL in a  Formula Tool. That way you can dynamically assign the sheet name and within the output toll change the entire path.

 

Hope this helps.

 

Best,

Jagdeesh

JCornn
7 - Meteor

Hi @JagdeeshN ,

 

I have not used that process before. Would you have an example?

 

Thank you

JagdeeshN
12 - Quasar
12 - Quasar

Hi @JCornn,

 

Please find attached a sample workflow.

 

Hope this helps.

 

Best,

Jagdeesh

Labels
Top Solution Authors