3 Replies Latest reply on Jun 29, 2018 5:51 AM by Mavis Liu

    Date extraction from folder

    huiying ong

      Hi,

       

      Can I check if I am linking my tableau to excel / csv files, am I am able to extract the last modified date of the files ?

       

       

      thanks.

        • 1. Re: Date extraction from folder
          Mavis Liu

          Hi Huiying,

           

          Sorry I'm not sure what you mean by the last modified date.

           

          The Extract will be refreshed when you tell it to, either manual or on a schedule basis. Having the modified date updated on your drive will not trigger an extract refresh.

           

          To see where your extract is pointing to, right click on the data source and go to properties:

           

          2018-06-29_08h32_02.png

           

          2018-06-29_08h32_10.png

           

          Thanks,

           

          Mavis

          • 2. Re: Date extraction from folder
            huiying ong

            Hi Mavis,

             

            Based on my previous email, I will want tableau to extract the date as of 29Jun18 (my last modified date for my source).

             

            What I mean :

            eg.

            Date : 1 Jun 2018

            Data last modified date : 1 Jun 2018.

            Expected date from tableau : 1 Jun 2018

             

            Date : 2 Jun 2018.

            Data last modified date : 1 Jun 2018 ( files was not updated)

            Expected date from tableau : 1 Jun 2018. ( as per last modified date)

            • 3. Re: Date extraction from folder
              Mavis Liu

              Hi Huiying,

               

              Please see this thread which asks a similar questions: how to extract a character from an external file?

               

              Unfortunately I can't think of a way of how you could do this as the modification datestamp sits within windows and Tableau cannot access those details unless it's in a data source.

               

              Maybe there's some additional scripting that could help you do this, but unfortunately I personally don't know how to do this, sorry!

               

              Thanks,

               

              Mavis