![]() In this example, the option “Copy the value of the previous record” will be selected, so that the amount of the monthly payment is repeated in each of the rows created. Set the value of the rest of the fields of the new rows to: “Null”, “Null or Zero” or “Copy the value of the previous record”.Define the name of the new field to be created with the values between the range of the two fields “ Start Date” and “ End Date“, in this example we will call it “ Payment Date“.Once it has been indicated that two fields will be used and the name of the fields, the interface offers you the possibility of the following configurations: Since we require new records to be added to the data source, we will use the new type of step: “ New Rows”.Īnd the first thing to indicate is that to fill gaps the range of values between two date fields is used: “ Start Date” and “ End Date“. You work for a mobile phone company and your boss asks you to compile the income report for your current batch of contracts, listed below: ![]() On the right side of the screen, you will be able to see the dates to be added, in addition to seeing the final data table including the new rows.Īnother example can be seen in Tom Prowse’s challenge from week 37 of Preppin’Data in 2021, where the following scenario occurs: Establish the increment in the value that will be used when generating the new records, in case of dates the increments can be established in days, weeks or months.Use the minimum and maximum values of the reference field (“Order Date” in this example) or select a range between those values.Select to add the new rows to your existing field or create a new field to preserve your original data.Once you have indicated that a single field and the name of the field will be used, the interface offers the possibility of carrying out the following configurations: In this example, it is required to add rows from a single field: “ Order Date”. The first thing we must indicate is whether the filling of gaps will be taking a range of values from a single field or defining the range with the values of two fields. In the data for days 21 and 25 there are no records, since no sales were made. Let’s try the following data corresponding to the sales made during a week. ![]() The new step type: “ New Rows” will help you create the rows to fill in the gaps for the missing days and set the sales value of the new records to zero. You work with a sales data source, where there are only records for the days when sales were made and you require that there is at least one record in the data source for each of the calendar days. (whole numbers) as for date fields, through selecting options among the different available configurations. With the new feature, now filling gaps is within everyone’s reach and is a fairly simple task, since it has an intuitive interface that allows generating the gaps records for a set of sequential data, both for fields with numerical values. Until before version 2021.3.1, you would most likely have to use the “Scaffold” technique, which, although it helped us with the task of filling in the gaps in the critical data, it turned out that not all the people who needed it knew about the technique and how to implement it. ![]() When you work with a dataset that has gaps in sequential data, you may require the generation of new rows to fill gaps in critical data, either to facilitate the analysis of your data or detect trends or create certain types of visualizations, as we remember that Tableau will only represent marks where data records exist. The new version of Tableau Prep Builder 2021.3.1 is now available and brings us a very important new feature, a new type of step known as “ New Rows”.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |