1 Reply Latest reply on Jun 10, 2016 3:37 AM by khalid norat

    How to extract excel source filename in Tableau

    namrata patil

      Hi All,

       

      I have monthly basis data in excel file.

      In the excel source file, there is no column as Date.

      The excel source filename will be saved as "Data_mmddyyyy" format (eg: Data1_06012016, Data2_06022016, and so on).

      Like this every day a source file will be maintained.

      Since there is no Date column in any source file, therefore is there any way to derive date from the excel source filename?

       

      Kindly assist.

       

      Thank You.