JsonSpread Process
Spread values from json columns
| nameIncomeJson |
|
{"name": "John","income": 50000} |
|
{"name": "Marry","income": 60000} |
|
{"name": "Peter","income": 100000} |
|
{"name": "Donald","income": 80000} |
->pipe(new JsonSpread(array(
"nameIncomeJson" => array("name", "income")
)))
| nameIncomeJson | nameIncomeJson.name | nameIncomeJson.income |
|
{"name": "John","income": 50000} |
John |
50,000 |
|
{"name": "Marry","income": 60000} |
Marry |
60,000 |
|
{"name": "Peter","income": 100000} |
Peter |
100,000 |
|
{"name": "Donald","income": 80000} |
Donald |
80,000 |
JsonSpread helps to decode json string column and then spread its values into multiple columns. This process is very useful when you want to make calculation bases on the value inside json string.
__Spread all values from a json column__
```
->pipe(new JsonSpread(array(
"nameIncomeJson"
)))
```
__Spread certain values from a json column__
```
->pipe(new JsonSpread(array(
"nameIncomeJson" => array("name", "income")
)))
```