This page has an error. You might just need to refresh it.
Unable to find an action for 909;a: {"id":"909;a","state":"SUCCESS","returnValue":{"isChatterEnabled":true,"contextUser":{"id":"0054T000001NHMqQAO","userType":"Guest","photo":{"smallPhotoUrl":"https://community.tableau.com/img/userprofile/default_profile_45_v2.png"},"displayName":"Tableau Community Forums Site Guest User"},"showAnnouncement":false},"error":[]}
Failing descriptor: {forceCommunity:tabset}
I'm currently struggling with a problem which I thought Tableau Prep would be able to solve pretty easily. I have a bunch of excel sheets of water quality test results. Unfortunately they're really poorly laid out. I have rows for each site and test, with columns for each parameter tested. Unfortunately, each test is represented by two rows, with one row having the results for roughly half the parameters tested, and the other row having the results for the other parameters. There's no overlap between rows.
I'm hoping to merge the rows so that I just have a single row with all parameter results for each test at each location.
Is there a simple way to do this? - I've attached a screenshot showing how the data s setup in excel.
Can I publish and schedule a Tableau Prep flow (2024.3 Version) that outputs 3 .csv files to a shared OneDrive/SharePoint "Outputs" folder location? What are my other options?
I have created a Tableau Prep flow that has 6 connections (4 .csv files and 2 .xlsx files).
I want to direct the 6 input files to come from a shared OneDrive/SharePoint "Inputs" folder location, using the OneDrive and SharePoint Online connector, so that whenever the input files are overwritten by somebody in the team the changes are taken into account.
I have a .hyper file coming out as a Published Data Source to be subsequently used in a Tableau workbook and this works well.
However, I also want 3 .csv files to be pushed into a shared OneDrive/SharePoint "Outputs" folder location. Can I achieve this (particularly when considering the planned schedule to run the flow each morning)?
After some research I understand that csv outputs in Tableau Server/Cloud are not fully supported - so I'd like to know what my options are.
I have tried reading through the following links to help support this scenario as well:
I am using Tableau Prep Builder to do some initial data sighting of DB tables (MSSQL DB in this case).
I am adding an Input object for a table , unchecking certain columns I don't need, then I add a "Clean Step" and use that clean step to preview my data.
However, when I update the data in the underlying DB table, the preview in Prep Builder is not reflecting those changes; and there is no "refresh" or anything command or menu entry that I could find anywhere. How can I get Prep Builder to refresh that data in the preview?
Sadly, the update button in the tool bar only works for files. In my experience with Prep, if you need to refresh the data show in your clean step, then you must close prep and open again your flow.
Sometimes, if I left clicked on the left panel, insert the password again, it refreshed the data, but it does not always work.
If this post assists in resolving the question, please "Upvote" it or "Select as Best" if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I am trying to follow the Tableau Prep courses but I cannot find the course files used in all demos/videos. For example, there is a flight file used but I don't have a copy. How do I get them? There is no place for me to download within the lessons.
How can I pivot rows into columns for two string dimension data?
Hello 😀
I want to know how to pivot rows to columns for two dimensions.
For example..
I would like to separate all the items in [NAME] into individual dimension field names, each containing the country information (where they are from).
I tried several methods to pivot the data and also experimented with a simple calculated field, such as: IF [NAME] = "Robert" THEN [COUNTRY] END. However, I realized this approach is not practical when dealing with a large number of names in the dataset.😗
Is there a simple way to handle this using basic Prep Builder functions? Thank you in advance!😁
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.