Tutorial
Raadpleeg ChatGPT
Tutorial sample
$value sample
$substr sample 1
$substr sample 2
$strcat sample
$strlen sample
$substr_before and $substr_after sample
$replace sample
$findstr sample
$lower sample
$random sample
* multiply sample
+ add sample
- minus sample
$round sample
$div sample
$floor sample
$ceil sample
$count sample
$sum sample
$localdate sample
$if sample
$loop sample
$index and $last sample
$filter sample 1
$filter sample 2
$groupby sample
$orderby sample
$case sample
$function sample 1
$function sample 2
$var sample
$and $or $not sample
$messageid sample
$coalesce sample 1
$coalesce sample 2
$lpad sample
$rpad sample
CASE $strreplace
CASE JSON - JSON
CASE JSON - XML
CASE JSON - CSV
CASE JSON - HTML
Brondata (Json, XML of CSV)
+
DataMixer$cript
=
Resultaat
File