Forum Discussion

Dai9210's avatar
Dai9210
New Contributor II
4 years ago

Create a reusable pipeline to dynamic apply default value

Here is the scenario: I want to apply default value to a table, and the column(s) which need to apply default value might be changed. What I am doing is to: Create a parameter csv file with the...
expression_language
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago
Copy Link

Hey @Dai9210,

Here’s one solution for you:

Default Values_2021_09_27.slp (8.6 KB)

The pipeline sends all records in an array. That array is joined with the default values 1=1. Right after, follows a mapper with expression that maps the $group array, and within that map, there’s a nested .mapValues() function that checks if the key is in the incoming document (apart from the $group). If it is map Its value, if not , keep the actual one. After the mapping is done, jsonSplitter will split the $group.

Regards,
Bojan