Create a custom table
You can create a custom table from a source data table to define and edit the columns that you want to work with. All your custom tables will appear as common data tables in the finder.
Why can't I see my custom table in the finder?
Take in mind that new custom tables may take up to several minutes to be available in Data Search → Explore Your Data. Try using the refresh button above the finders from time to time to check if it is available.
This may be useful in a variety of situations, especially for tables such as
my.upload. For example, when you send data to the Devo platform from a source that has not a tag defined yet (
my.app) or uploading a file (
my.upload), you can query the necessary data, perform the desired operations and create a custom table only with the required columns. You can also use the Autoparser and then create a custom table if you need a specific set of columns without getting rid of the original with the whole set.
- Go to Data Search and open the data table you want to use as the base for your custom table. Perform the necessary operations to obtain the data you want.
- Select Additional Tools → Custom tables → New.
Give the table a name.
You have to select an option from the dropdown for the first two tag levels. The options are
Then you have to manually enter the third and fourth tag levels of the table name.
Configure the custom table fields.
Select New Field to add new columns to the custom table.
Select the Query field value dropdown to choose which column you want to bring from the source table to your custom table. Type inside the New field name to specify the name you want to give it.
Click the pencil icon to activate the Field type so you can change its data type.
Click the trashcan icon to delete the column from your custom table.
- Click OK when you are done. The new custom table will appear in Data Search → Explore Your Data. As said above, this may take several minutes.
We recommend using each prefix for a different kind of use or purpose to better identify the kind of table it is. For example:
my.synthesis→ for custom tables from
my.techfor custom tables from
my.parserfor union tables.