Is it possible to make an excel spreadsheet TAB a FIELD option? PLEASE HELP

I can't find anything on this... please help.

This is the full formula i'm trying to recreate, just having trouble finding CELL("filename")

=INDEX('Clients'!$A:$I,MATCH($AO3&$AV3&MID(CELL("filename",$H3),FIND("]",CELL("filename",$H3))+1,255),'Clients'!$D:$D&'Clients'!$F:$F&'Clients'!$E:$E,0),1)<>"","Yes","No")

Workflow

Regex

Transformation

Preparation

Predictive Analysis

Database Connection

Accepted answers

NicoleJohnson

When you input your data, choose the configuration option to Output File Name as Field and use the Full Path option... you can then parse out the tabname at the end of the FileName field after the ||| delimiter. For example, FileName would show up as C:\Users\NJohnso128\Desktop\Alteryx101SampleData.xlsx|||`Manager by Region$` and you could use Text to Columns to split out the 'Manager by Region$' portion, and some text formulas to get rid of the ' and $ punctuation.

All comments

NicoleJohnson

Davidmcho

I'm a total beginner here at this, is there a way you can show me how to do this using Text to Columns and Text formulas?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703