Difference between revisions of "Manuals/calci/FLATTEN"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''FLATTEN(Array,ForceFlatten,PreserveBlanks)'''</div><br/> *<math>Array</math> is set of values. ==Description== *Flattens the cells of a multi-d...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
*Flattens the cells of a multi-dimensional array into a one-dimensional vector. | *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. | *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 | ||
| + | |||
== See Also == | == See Also == | ||
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