DTL Helper-Powerful Data Transformation

Example

{ "out": { "name": "(: fne( $display_name $first_name 'unknown user' ) :)" } }

Scenario

For developers needing to merge user profile information from multiple data sources into a unified format, ensuring that a display name is always available.

Example

dtl myfile.csv

Scenario

Data analysts converting CSV files to JSON format for easier data manipulation and integration with web applications.

Example

{ "out": { "averageAge": "(: math.round( avg(map($users 'age')) ) :)" } }

Scenario

Data scientists preparing datasets for analysis by calculating the average age of users from a JSON file containing user information.

Example

dtl -f transform.dtl input.json output.yaml

Scenario

ETL developers transforming large datasets from JSON to YAML format using a predefined DTL transformation file for integration with other systems.

Example

dtlr sample.json

Scenario

Developers and data analysts exploring and experimenting with data structures in real-time to understand data relationships and structure before applying transformations.