Versions Compared

Old Version 19

changes.mady.by.user Borja Moro Moreno

Saved on

compared with

New Version Current

changes.mady.by.user Juan Tomás Alonso Nieto

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tables

The table must be one of the following:

  • my.app → tables created by sending data from a new, proprietary data source.

  • my.upload → tables created by manually uploading a file containing data.

Info

Unless…

  • They have less than 4 tag levels, which makes them ineligible for the use of the autoparser.

  • They have been created by injecting data from another table, which are already properly parsed.

Events

Events must comply with the following conditions:

  • Events must contain the same number of fields in the same order.

  • Events must use delimiters in the same pattern in every event.

  • Events must use valid formats.

  • Timestamp data will be parsed as a string when presenting an invalid format. Check valid formats below:

    • ddd MMM DD HH:mm:ss YYYY → Thu Mar 29 00:21:05 2012

    • DD-MMM-YYYY HH:mm:ss.SSS → 27-Aug-2012 09:44:09.378

    • DD/MM/YYYY HH:mm:ss → 23/07/2019 07:55:00

    • DD/MM/YYYY H:mm:ss → 14/09/2012 9:42:05

    • YYYY-MM-DD HH:mm:ss.SSS → 2000-12-17 01:01:01.123

    • YYYY/MM/DD HH:mm:ss → 2012/08/25 06:48:18

    • YYYY/MM/DD → 2012/08/25

    • yyyy-MM-dd:hh:mm:ss+gmt → 2012-08-16:10:29:17+0200

    • yyyy-MM-dd hh:mm:ss.micros → 2000-12-17 01:01:01.123456

    • Epoch.millis (recognized as a float, you need to change it) → 1234567890.123

    • Millis (recognized as an integer, you need to change it) → 1584100816544

Info

Disparate data

If the events do not conform to these requirements, it may be imposible impossible to extract a pattern and an error will pop up to further specify the reason. You can then parse it informing you that your data has been parsed with errors. This means that some fields could not be parsed properly and you will see null values wherever the error occurred.

To avoid this, you can parse this data manually using operations such as Split (split) and later create a custom table. For my.app data, you can also contact customer support to request a custom parser.

...