csv file, or to publish the output as a data source to a server. Add Output: to save the output to an extract file (.tde or.This time, we are going to drop it on Union. Select the step you want to union data with or, as with Join, drag-and-drop to union files. The Union and Join icons appear, and we are dropping it on Join: Here we’re dragging the Clean step of the Calendar file on the Clean step of File 1. Add Join: You can select the step you want to join the data with, or you can drag-and-drop to join files.Tableau prefers to have all the values under one column as a long list of rows - Something like this: Product nameĪdd Pivot allows you to do this in 2 clicks. Add Pivot: to pivot the data - Once you add this step, Prep will ask you which fields to pivot.īased on how Tableau Prep Help explains it here in Clean and Shape Data, Tableau prefers data to be “tall” instead of “wide.”įor example, you may have a table like this one: Product name.You attach this tool to the previous step and select which fields you want to group the data by. Add Aggregate: to aggregate or group the data.Add Step: to get a better look at your table and perform cleaning operations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |