...
| Excerpt |
|---|
You can create nested objects by filtering strings. In this example, column headers and column values are nested into a single entity in a new column of Object data type. |
Functions:
| D generate list excerpts | ||
|---|---|---|
|
Source:
The following table shows a series of requests for inventory on three separate products. These are rolling requests, so inventory levels in the subsequent request are decreased based on the previous request.Source:
| date | reqProdId | reqValue | prodA | prodB | prodC |
|---|---|---|---|---|---|
| 5/10/21 | prodA | 10 | 90 | 100 | 100 |
| 5/10/21 | prodC | 20 | 90 | 100 | 80 |
| 5/10/21 | prodA | 15 | 75 | 100 | 80 |
| 5/11/21 | prodB | 25 | 75 | 75 | 80 |
| 5/11/21 | prodA | 5 | 70 | 75 | 80 |
| 5/11/21 | prodC | 30 | 70 | 75 | 50 |
| 5/12/21 | prodB | 10 | 70 | 65 | 50 |
...
