Forum Discussion
Solved
Add a column with the sheet name
Hi all, after getting my data from an Excel sheet, I want to add a column with the name of the worksheet (not the workbook) as a value. Example: I get my data from Actuals2018.xlsx with shee...
ruben_BE，
Yes. You can create a custom column based on the Date field.Date.MonthName([Date],"en-us")
Regards,
Lydia
Hi Lydia,
thank you for reply.
When applying this method, I don't get to adding the 'Table name' or de 'Worksheet name' as a value in a new column. I can only create a new column based on values in other columns.
Thank you very much for your assistance!
Best regards,
Ruben.
ruben_BE，
Yes. You can create a custom column based on the Date field.
Date.MonthName([Date],"en-us")
Regards,
Lydia