Document toolboxDocument toolbox

Using the autoparser

Owned by Borja Moro Moreno
Last updated: Jul 18, 2024
3 min read

 

[ 1 Autoparsing a data table ] [ 2 Autoparser window settings ] [ 3 Autoparsing an already parsed table ] [ 4 Autoparsing tables with special objects ]

Autoparsing a data table

10_Using the autoparser.png

  • Access the table you want to parse.

  • Click the option menu in the toolbar and select Source table → Autoparse.

  • Configure the parsing as desired using the settings in the Autoparser window (see section below).

  • Click Confirm when you finish.

Autoparse option not showing

The option will not appear if the requirements explained here are not met.

Autoparsing result

The autoparsing process will not create a new table but transform the original table instead so it can be fully used in Devo.

Autoparser window settings

20_Using the autoparser.png

Event analysis

Samples

If you want a different set of samples, click the Reload samples button next to the No. of Samples dropdown (see icon below). This will lead to two possible scenarios depending on the temporal aspects of your query:

  • Fixed period query: new events are not being received so you will get a message informing you that "no new events were found" and thus changing the samples is not possible.

  • Real-time query: new events are being received so this will load the last 200. If the structure changes, new delimiters will be considered. If the structure is too different, you will get the "Disparate Data" error message explained before.

Delimiters

Select or deselect the symbols identified as possible field delimiters by clicking in the Delimiters area or one by one in the Sample area. The symbols are displayed in colors to show if they are going to be used when parsing.

  • All the symbols in the sample are going to be used.

  • None of the symbols in the sample are going to be used.

  • Some of the symbols in the sample are going to be used. A number is displayed below to specify how many of them.

Fields from sample

Names

Click on each field and write the intended name for each of them.

Autocomplete field names

You can enter the command /fillNames in any of the name fields to autocomplete all the available fields with standard names (column1, column2…)

Data types

Use the dropdown menus to select the data type for each field. The options in the dropdown are automatically offered based on the detected data patterns.

Exclude

Mark the Exclude checkbox for any fields you do not want to include in the parsed table. When you do so, the corresponding name field will be automatically disabled.

Delimiter

This column is informative only. It lets you know the delimiter used to mark the end of the string that will be contained within this field.

Autoparsing an already parsed table

If you are not happy with the result for whatever reason, you can use the Autoparser again. However, it is not possible to apply changes selectively; the table will be reset to its original unparsed state for you to start over.

You just need to open the Autoparser as instructed before. Don't worry if you have second thoughts after clicking because you will receive a warning message. You can either cancel and keep the table as it is or restore it to parse it again with different settings.

If you choose to restore it, you will be forced out while the table goes back to its original unparsed state. To parse it anew, you need to access it again through the Data Search and open the Autoparser once more.

Autoparsing tables with special objects

It is possible to autoparse special objects such as JSON. Although the concept is the same, the procedure varies. Check the article Autoparse a JSON object to know more.