Using the autoparser
Autoparsing a data table
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
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:
|
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.
| |
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 |
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.