2/19/2023 0 Comments Timeplus com![]() ![]() For example, if I want to build a dataset that includes information about all the permits in the site, I would include the PermitApps table and use that as my "base" table since that table includes all permits no matter which type or what status it is in. This would be a table that contains the most general information that you want to include in the dataset. ![]() When joining multiple tables, it is typically a good idea to start with a "base" table. On the Join step, the tables that you selected on the previous step will all be shown in the top part of the page. View the guide to learn how to use this resource. TimePlus includes a very powerful resource for finding Primary and Foreign keys in a table. This is the step where knowing what the Primary and Foreign keys of the table will be necessary in order to build an accurate and functional dataset. By joining the tables together on a common field, the dataset is able to tell which information belongs to which record so that when you choose fields to display, the dataset will create a row for information that belongs together. This step is where you link up the tables and specify what fields to join the tables on. This is also helpful if the table name is vague and you want to give more detail. This is helpful if the original name of the table is longer and you want to simplify it. Rename: In the text box to the right of the table name, you can choose a different name for that table to appear by in the dataset.This will load the contents of that table into a new tab in your browser. View: To view the contents to the table before you move to the next step, you can click the table icon to the left of the table name.Remove: If you added the table by accident, you can remove it by clicking the red "X" to the left of the table name.Once it is added to the list, the table will appear on the right side of the page and you will have several options available to manage that table: You can click on the name of the table or dataset to add it to the listing of tables you want to use. This includes the other datasets that show on the "Manage Dataset" page. This step allows you to choose which tables you want to bring into the dataset. When a dataset is included in a report or another dataset, this option will be unavailable since changing the dataset may break the report or dataset that depends on it.The "Overwrite" option will allow you to overwrite an existing dataset with the version that you are going to create.Other Users: Everyone with a valid account.Group: Shows a multi-select check box to allow you to choose which employee groups are able to view the dataset.The Share level option will allow you to choose who is able to view this dataset.Example: a listing of years where applications were filled out.This option is useful if you are trying to build a dataset that has duplicate records and you need only one record for each value.The "Distinct" check box will remove duplicate records from the dataset if checked.The "Created By" field displays your username to show who is the creator of the dataset. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |