| Excerpt |
|---|
You can extract one or more values from within a column of values can turn data into meaningful data. This section describes how to extract object elements by the following transformation. |
Source:
For example, suppose your restaurant dataset includes a set of characteristics in the restFeatures column in the following JSON format, from which you are interested in the total number of seats in the restaurant.
...
| D trans | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Results:
| restFeatures_TotalTable Seats | restFeatures_CounterSeats |
|---|---|
| 36 | 8 |
After converting into separate columns, you can perform a simple sum of the TotalTableSeats and CounterSeats columns to determine the total number of seats in the restaurant.
The final table looks like the following:
| restFeatures_TotalTable Seats | restFeatures_CounterSeats | TotalSeats_Restaurant |
|---|---|---|
| 36 | 8 | 44 |
