• Tableau Prep - Automatically refresh wildcard union to include all files

    I am right now stuck while testing one of my flow in Tableau Prep builder. While adding new files to the existing folder the published flow in Tableau server doesn't pick all the files mentioned in the wildcard union ...
    UMA SANKAR SAHOO
    last modified by UMA SANKAR SAHOO
  • What date formats are acceptable in Prep/Desktop?

    I'm having trouble finding a list of acceptable formats for Date type.  Example, I have some raw data in Tableau that is of format "Aug-19" which doesn't appear to be acceptable, so i'm building a calculated fiel...
    david.s.12
    last modified by david.s.12
  • Tableau Prep 2019 2.1 - Union two xlsx files - rows of data missing

    I have two xlsx files - exact same columns in each with rows of customer data - the only difference is the time period of the data.  I did a Union in Prep.  The only changes I made were to convert some strin...
    Rose Lawhorne
    last modified by Rose Lawhorne
  • Tableau Prep is not showing the full characters in the field

    I'd been using Prep to clean my data from CanvasData (Instructure LMS named Canvas).   On each CanvasData file, there are several fields with the name "id" and these fields use a big number  like these ...
    David Daza
    last modified by David Daza
  • Tableau Prep Command Line output is out of order

    Like I stated in the title, when I run a flow in Tableau Prep, the output is ordered in the order that I specified. See below:   But when I run the flow using the command line, the order of the output is compl...
    Rick Loveday
    last modified by Rick Loveday
  • Range of Dates in Tableau Prep is not picking up all

    I have put the dates as 1/1/2016 to 2020 but its reverting to 5/8/2016 any ideas why?  The data consists of Jan to April 2016 dates  
    Nancy Ratwatte
    last modified by Nancy Ratwatte
  • Filling in missing values

    I'm prepping some data downloaded from Census.gov.  Some datasets don't repeat a particular column value if it repeats.   For example see screenshot below, the first 17 rows of data should have '2402205350...
    david.s.12
    last modified by david.s.12
  • Tableau Prep After join I am getting two fields with Field Name, Field Name-1, Field Name-2 and so on and row size is different can anyone explain why ?

    I am a new tableau prep user and I am trying to join two tables but I am getting repeated field names   Field Name, Field Name-1, Field Name-2 and so on with different number of rows.   I have tried to un...
    Arpit Vijay
    last modified by Arpit Vijay
  • Prep Output from Aggregate cell produces 0 rows; however Preview in Desktop is correct

    Good Morning!   My output from this aggregation produces 0 rows (Figure 1 and 2). The aggregation inspection is showing 283 rows as expected (Figure 3) Preview in Tableau Desktop produces the correct result (F...
  • How to perform nested calculations in Tableau Prep?

    I'm trying to move all calculations from tableau to tableau prep, but when I tried to create the below calculated field, it shows and error i.e the sum function cannot be used in tableau prep   IF ISNULL(ZN(SUM...
    Jithin James
    last modified by Jithin James
  • Tableau Prep - Pivot/Merge Data Help

    I have some AFL match data. I have separate columns for the home team, home score, home goals, home behinds, away team, away score, away goals, away behinds. I'd like to change it so that there is a column called "...
    Penelope Reilly
    last modified by Penelope Reilly
  • Weird type of cross map pivot sought in Tableau Prep

    Hi,   I have a table with two columns I'd like to pivot to collapse the number of rows and aid in analysis.   My key column is ObjectID.   The first column to pivot is something like attribute type: ...
    Paul Albert
    last modified by Paul Albert
  • Grouping data and aggregating string fields

    Is it possible when grouping data to aggregate a string field by appending the strings from grouped data together?  I do not see this option in the aggregate parameters.  Example below.   ID Code Value ...
    James Alaly
    last modified by James Alaly
  • Wildcard Union does not add the files to filepath

    Hi,   I am trying to get 10 Excel files together into one table. I can add them one by one and union them, without a problem. What wont work is making a wildcard union. I am using Tableau Prep 2019.2.3 In the f...
    Can Cinar
    last modified by Can Cinar
  • ORA-00972 Error in 2019.2

    I upgraded to 2019.2 and am getting an Oracle ORA-00972: identifier is too long error. The flows have run fine in all the other versions of Prep I've used. Anyone else using Oracle in their Prep flows seeing this? I a...
    Kate Brown
    last modified by Kate Brown
  • How to only export the summary view in Tableau Prep

    Good afternoon,   I would like to know if there is someway to export the Tableau Prep summary view only, either in an Excel or a flow. All I need is to show the mismatched values in an automated monitoring repor...
    philip.watkinson
    last modified by philip.watkinson
  • REGEXP_REPLACE details

    Hello again, hope, someone can help me with that. I need to clean certain extra symbols from the mid of the string. Something like that: wa-dashchapin <i:0#.w|apple\wa-dashchapin> ko-lanar <i:0#.w|orange\...
    Marina Talyanskaya
    last modified by Marina Talyanskaya
  • Using Tableau Prep to find the header row

    Hi all,   I'm new to working with Tableau prep but think it could be a really powerful tool to help my team. We have some limited alteryx experience but only a couple of users have access where as the whole team...
    Alexis Scott
    last modified by Alexis Scott
  • Combining Data in PREP

    Hi everyone - I'm trying to do something in Prep I've never done before.   Seems simple but I'm not getting it to work. I have a data set that looks like this: All I'm trying to do is combine weights w...
    Brian Boddy
    last modified by Brian Boddy
  • Command line run of prep flow fails after chancing the site name in json

    Hi,   I have an issue with prep flow run from the command line. I have built flow to point tableau server site A. I'm able to run the flow in command line with site A in a json config file.   The issue occ...
    Esa Raivio
    last modified by Esa Raivio