1 Reply Latest reply on Jul 9, 2018 1:04 PM by Jim Dehner

    Extract Date from File name




      I am new to tableau prep....I have a situation where I need to extract date which is in my file name...


      Eg: Book1 06-15-2018.xlsx, Book1 07-27-2018.xlsx


      I want to do a wild card union and in the first step I want to extract date from the file....

      How can I do that???


      Someone help me...





        • 1. Re: Extract Date from File name
          Jim Dehner

          Hi see below


          I had a text folder with 3 files


          I loaded July into Tableau




          then to get the other files





          then select apply

          and the files are loaded





          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.