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
Solved! Go to 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,
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!