Creating new column based on the table name

[Balrajh1]

Hi 

I am trying to create new column based on the table name as field (not file name)

ex: Excel sheet has Revenue, Expense as tabs name

I want to create field name as Type with Revenue as values. 

Type

Revenue

Revenue

Revenue

Thanks for the help

[Thableaus · Accepted solution]

Hi @Balrajh1 

Get the Full Path instead of the File Name, and parse that out (you can use regex)

REGEX_Replace(Full Path, ".*\|\|\|(.*)", "$1")

Cheers,

[bpatel]

hi @Balrajh1 ,

i am not entirely sure if this is what you are looking for but when bringing in the excel file you can select to import sheet names and use that to create your columns. 

hope this helps or is on the right track! let me know!