-
1. Re: Define Groups for age brackets but update data extract and they disappear
ShivaRam Chennapragada Oct 12, 2018 4:38 PM (in response to conacher)I'm not sure I follow you, are you creating the Group in live data source and then switching to Extract? You'll have to create the extract again when you make changes. Or, you can just create the grouping in Extract itself.
-
2. Re: Define Groups for age brackets but update data extract and they disappear
Michael Gillespie Oct 12, 2018 6:03 PM (in response to conacher)To follow on from Shivaram's question, what do you mean by "replaced"?
Are you refreshing the data in the extract, or are you doing a "Replace data source" activity? If you're doing the latter, that's likely the cause of the issue.
-
3. Re: Define Groups for age brackets but update data extract and they disappear
conacher Nov 7, 2018 4:28 PM (in response to Michael Gillespie)I have a scheduled job that overwrites the Excel data extract that I'm using with Tableau on a nightly basis. After the overwriting, the ages data is no longer grouped.
It's the same file name and the connection in Tableau doesn't change as the data file is located on a server.
Is there a way to not lose the groupings when the file Excel file itself is overwritten?
Thanks!
-
4. Re: Define Groups for age brackets but update data extract and they disappear
conacher Nov 7, 2018 4:28 PM (in response to ShivaRam Chennapragada)I have a scheduled job that overwrites the Excel data extract that I'm using with Tableau on a nightly basis. After the overwriting, the ages data is no longer grouped.
It's the same file name and the connection in Tableau doesn't change as the data file is located on a server.
Is there a way to not lose the groupings when the file Excel file itself is overwritten?
Thanks!
-
5. Re: Define Groups for age brackets but update data extract and they disappear
Peter Fakan Nov 7, 2018 4:41 PM (in response to conacher)Hi Conacher,
Instead of replacing data source, have you tried to refresh extracts ?
Another alternative would be to create a calculated field off the native fields, then when you replace the data this isn't affected because instead of aliases your viz will be looking for a calculated field to do all the work.
HTH
Peter
-
6. Re: Define Groups for age brackets but update data extract and they disappear
ShivaRam Chennapragada Nov 8, 2018 6:27 AM (in response to conacher)1 of 1 people found this helpfulLike Peter suggested, instead of creating groups explicitly, try using a calculated field to create the groups, so the calc field recognizes new data and groups them as it should. It would look something like this,
IF [AGE] <= 29 THEN "29 and Under"
ELSEIF [AGE] >= 30 AND [AGE] <= 39 THEN "30-39"
ELSEIF [AGE] >= 40 AND [AGE] <= 49 THEN "40-49"
.
.
.
.
END
You'd have to replace the groups with newly created calc field in the views.
Hope this helps.
Best,
Shiva
-
7. Re: Define Groups for age brackets but update data extract and they disappear
sudheer.kumar.5 Nov 8, 2018 6:35 AM (in response to conacher)Hello Conacher,
I think Calculation would solve the problem.
Have you tried @peter fakan solution; calculated field?
Hope it helps.
S