📄️ Simple Transformation
The package includes a powerful, database-agnostic DSL for transforming your data after it has been extracted. This allows you to perform complex operations like joins (lookups), string manipulation, and math entirely within your database, ensuring high performance.
📄️ Chaining Transformations
You can chain multiple operations together to build complex logic.
📄️ Dynamic Usage
The transformation engine is designed to be fully serializable, making it easy to build a GUI on top of it. You can save the transformation configuration as a JSON object in the database and execute it later without writing any PHP code.
📄️ Available Transformations
All expressions are created using the Andach\ExtractAndTransform\Transform\Expr factory class.
📄️ Re-Run Saved Transformation
Once created, a transformation does not need to be re-defined each time, and can simply be run again.
📄️ Mapping
LEaT provides the option of performing a simple map, akin to an Excel VLOOKUP, on an array manually defined within the transformation. Assume we have the following table for this example.
📄️ Chaining Lookups
Lookups can be chained to return grandparent, great-grandparent (etc.) relationships.
📄️ Lookups
More powerful than maps, a lookup enables you to combine tables, performing a left join to return another value.