Advanced ECL (Part 2) – Super files, Working with XML, Free-form Text Parsing, and Machine Learning

May 17, 9:00 am – May 18, 5:00 pm – Remote via Microsoft Teams 

As we continue with a remote format, Part 2 classes will start on Wednesday at 9 AM, and will conclude on Thursday by 5 PM. When enrolling, please note these times are different from our onsite schedule in the past. Your instructor will send you a welcome email with details on what you will need after enrolling and login information before the class begins.

This course explores the concept of Super Files in ECL and the techniques for working with XML and JSON data, getting it into your HPCC Systems platform, and defining it to work with other data elements. This flows naturally into the detailed ECL support of Natural Language Parsing – creating pattern-matching definitions and using the PARSE function to extract data from either XML or free-form text.

Note: This course is the second in a two-part advanced series. People who attend the Advanced ECL (Part 1) – Working with Relational Data class should continue with this class.

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL (Part 1) – Concepts and Queries and Introduction to ECL (Part 2) – the Extract, Transform, and Load (ETL) Process training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

  • SuperFiles and SuperKeys
  • Simple XML Spray and Dataset Definition
  • Working with XML Data (simple, complex, and nested)
  • Complex XML Spraying and De-spraying
  • PARSE with XML Data
  • Spraying and defining free-form text data
  • PARSE with free-form text
  • New! An Introduction to Machine Learning

Class on Wednesday begins at 9am and concludes at 5pm.
Class on Thursday begins at 9am and concludes at 5pm. 

RELX and LexisNexis employees should register using your work email address and the approved promo code provided by their manager or contact training@hpccsystems.com.

Enroll in Advanced ECL (Part 2)