Combiner.CombineTextByRanges
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns a function that merges a list of text into a single text.
Combiner.CombineTextByRanges(ranges as list, optional template as nullable text) as function
| Argument | Description |
|---|---|
| ranges | The ranges to combine at. |
| optional template | The Combiner template. |
Each position identifies a tuple of position and length for a line where the text value should be placed. If the length of a text value for a given tuple exceeds the length specified by that tuple, then the value is truncated to fit. There is no checking for overlap of tuple ranges. If there are fewer text items than ranges, empty text will be used. If there are fewer ranges than text items, then they will not be emitted.
The template specifies the default characters over which the individual items are placed. If not specified empty text is used.