-
1. Re: Rows in Extract?
Alex Kerin May 22, 2012 2:23 PM (in response to Lee Murphy)1 of 1 people found this helpfulDon't think so - even opening the tde in a text editor doesn't show anywhere where that is stored as ascii
-
2. Re: Rows in Extract?
Logan RiggsMay 23, 2012 9:19 AM (in response to Lee Murphy)
I'm curious why you want to find out the number of rows. What is your usage scenario?
-
3. Re: Rows in Extract?
Lee Murphy May 23, 2012 10:42 AM (in response to Alex Kerin)Thanks for the quick response Alex!
-
4. Re: Rows in Extract?
Lee Murphy May 23, 2012 10:55 AM (in response to Logan Riggs)Hi Logan,
One of my new users to Tableau Server was recently getting familiar with the setup. After logging on and viewing some of the workbooks that we currently have published to server, he asked if there was a way to see which of the workbooks were using an extract vs a live connection? And for the workbooks using an extract, is there a way to tell how many rows are in the extract?
Based on Alex's response, it sounds like the answer is no.
Do you concur?
-
5. Re: Rows in Extract?
Logan RiggsMay 24, 2012 8:16 AM (in response to Lee Murphy)
I agree, there is no way to tell. Might be a worthwhile feature to add.
-
6. Re: Rows in Extract?
Jonathan DrummeyJun 8, 2012 3:04 AM (in response to Logan Riggs)
One way I've set up workbooks is to have a worksheet that just has SUM(Number of Records) in a text table, it's a hack but a quick way to get a sense of the extract. You could get fancy with it an include the last updated date, and if there are any timestamps on the records then use some aggregate calcs to break down how many records were added.
Jonathtan
-
7. Re: Rows in Extract?
Leigh Fonseca Dec 4, 2012 12:33 PM (in response to Jonathan Drummey)Jonathan,
Thanks for the tip. I think I'll set something like this up today. We've been trying to troubleshoot issues around extracts not refreshing the complete data set (due to problems on the source data side) and needed a quick way to see how many rows per refresh were being updated. Nice and simple.
Thanks!
Leigh