Difference between revisions of "Manuals/calci/FLATTEN"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
==Examples== | ==Examples== | ||
*FLATTEN([[1,2,3],[9,8,10],[17,13,21]]) = 1 2 3 9 8 10 17 13 21 | *FLATTEN([[1,2,3],[9,8,10],[17,13,21]]) = 1 2 3 9 8 10 17 13 21 | ||
| + | *FLATTEN([[1,3],[9,2],[10,3],[12,18,1]]) = 1 3 9 2 10 3 12 18 1 | ||
| + | *FLATTEN([["a","b","c"],["e","f","g"],["p","q","i"]]) = a b c e f g p q i | ||
Latest revision as of 22:18, 27 February 2020
FLATTEN(Array,ForceFlatten,PreserveBlanks)
- is set of values.
is set of values.Description
- Flattens the cells of a multi-dimensional array into a one-dimensional vector.
- Flat data is described as data which contains values in all cells within the table.
Examples
- FLATTEN([[1,2,3],[9,8,10],[17,13,21]]) = 1 2 3 9 8 10 17 13 21
- FLATTEN([[1,3],[9,2],[10,3],[12,18,1]]) = 1 3 9 2 10 3 12 18 1
- FLATTEN([["a","b","c"],["e","f","g"],["p","q","i"]]) = a b c e f g p q i