These videos were created by Allan Wrobel (Consulting Software Engineer). Allan has been working in the IT industry his entire adult life and has been an employee with LexisNexis Risk Solutions Group since 2010.
How to... |
|---|
Use ECL Macros Session 1- A worked through case |
Use ECL Macros Session 2- A worked through case |
| Use ECL Macros Session 3- A worked through case Generating an email using ECL to act on the information discovered in the previous session |
| Use ECL Built in Functions: PROJECT |
| Use ECL Built in Functions: TABLE (Vertical Slice) |
| Use ECL Built in Functions: TABLE (CrossTab) |
| Use ECL Built in Functions: ITERATE |
| Use ECL Built in Functions: PROCESS (Part 1) |
| Use ECL Built in Functions: PROCESS (Part 2) |
| Use ECL Built in Functions: GRAPH |
| Use ECL Built in Functions: NORMALIZE (COUNT Variant) |
| Use ECL Built in Functions: NORMALIZE (Child Dataset Extraction) |
| Use ECL Built in Functions: NORMALIZE (Additional Information) |
| Use ECL Built in Functions: DENORMALIZE (Single Record Presentation Variant) |
| Use ECL Built in Functions: DENORMALIZE (GROUP Presentation Variant) |
| Use ECL Built in Functions: ECL DICTIONARY (Examples of use) |
| Use ECL Built in Functions: Working with distributed data (TABLE, ROLLUP and AGGREGATE) |
| Use ECL Built in Functions: ROLLUP (Part 1) |
| Use ECL Built in Functions: ROLLUP (Part 2) |
| Use ECL Built in Functions: ECL #EXPORT and #EXPORTXML |
| Use ECL Built in Functions: DEDUP |
| Understand the differences Between Build and definition files in HPCC Systems |
| Use Aggregates on sub sets of data in a cross tab report |
| Learn about ECL Gotchas: Explicit return types from functions |
| Use ECL PROJECT different from other built Ins |
| Be clear about the context in which the ECL FUNCTIONMACROs run |
| Be wary of using the Compiler hint DISTRIBUTED in ECL |
| Find a Better way to optimise out file re-distributions using DISTRIBUTED |
| Resolve common ECL errors with unhelpful compiler messages |
| Understand the Distribution of data on HPCC Systems, with an example |
| Use ECL/HPCC Systems Events, Including Scheduling Events |
| Understand the idiosyncrasies of ECL MACROs and #EXPAND |