Accumulate strings data transformation function adds strings from previous records together, although it is possible to implement this functionality using variables the decision was made to create a separate function for it. The benefit of this approach is simplicity and performance. An alternative approach is described in this support forum post
Accumulate strings is one of those functions where it easier to show what is does than to explain it
A working example
Source Data
| Record No | Key | Value |
|---|---|---|
| 1 | 1 | To Be |
| 2 | 2 | Or |
| 3 | 3 | Not To Be? |
| 4 | 1 | Green, |
| 5 | 2 | Long, |
| 6 | 3 | Socks |
Transformation Result
| Record No | Key | Value |
|---|---|---|
| 1 | 1 | To Be |
| 2 | 1 | To Be Or |
| 3 | 1 | To Be Or Not To Be? |
| 4 | 2 | Green, |
| 5 | 2 | Green, Long, |
| 6 | 3 | Green, Long, Socks |
Direct link, no registration required.
