1 Reply Latest reply on Nov 1, 2012 3:46 PM by Russell Christopher

    Live Connection vs Extract: Distinct Count

    Zachary Hagopian

      Hi,

       

      I was wondering why I am able to take a distinct count in a file that is based off an extract, but when I try the same thing in a file that is connected live, I can no longer do a distinct count.  The files are identical except for the connection type.  Thanks.

        • 1. Re: Live Connection vs Extract: Distinct Count
          Russell Christopher

          Hey Zach -

           

          Based on your description, I'm guessing that your data source is a text file, Excel workbook, or Access database.

           

          We access all three of these sources via the Jet (MS Access) database engine, and since it is a bit long in the tooth, it doesn't support the ability to do a distinct count. Fortunately, the Tableau fast data engine does.

           

          You'll find that distinct count is there for you via Oracle, SQL Server, etc, too.