Free Trial

Alteryx Designer Desktop Discussions

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

how to use file name as sheet name when we have multiple sheet

Beckyli
8 - Asteroid

how to use file name as sheet name when we have multiple sheet

Beckyli_0-1668055962180.png

 

 

1 REPLY 1
grazitti_sapna
17 - Castor

@Beckyli , Please use the below formula to get your desired result. You can use Regex to get sheet names from file name. Attaching workflow for your reference.

 

grazitti_sapna_0-1668058927684.png

 

Sapna Gupta
Labels
Top Solution Authors