Alteryx Designer Desktop Discussions

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

Get Sheet Name From Excel

fjlorenzo
8 - Asteroid

Hi, can someone help me? How can I get the sheet name from Excel file and put the sheet name on the formula tool. Below is my sample workflow. Thank you for your help.

 

 
 

Get Sheet Name.jpg

 

23 REPLIES 23
LIEZL
6 - Meteoroid

This worked for me! I changed the option to get list of sheet names and it worked. Thank you!

lumjingbki
8 - Asteroid

@AkimasaKajitani the macro is helping to extract data from different sheets. I also want the "Sheet names" in the output file. is there any way to achieve this

AkimasaKajitani
17 - Castor
17 - Castor

Hi @lumjingbki ,

 

I think the sample workflow which uploaded by @marcusblackhill is work well for you. Did you check it?

 

lumjingbki
8 - Asteroid

@AkimasaKajitani, yes I the solution thank you

Labels