Tuesday, 20 December 2022

Pentaho - JavaScript to find string position & find substring

var text = Field_000;

var start_pos = text.indexOf(" W=");

var end_pos = text.indexOf(", U=");

var out_record_count = text.substring(start_pos+3, end_pos);

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...