Downloads
Power Query MSplitters and combinersIntermediate

Combiner.CombineTextByDelimiter

Returns a combiner that joins several text values into one, with a chosen delimiter between them.

Syntax
Combiner.CombineTextByDelimiter(delimiter, optional quoteStyle)

Returns: A function that you pass to a combine step such as Table.CombineColumns, or call on a list. It returns one text value.

What it does

A combiner is the opposite of a splitter. Combiner.CombineTextByDelimiter builds a rule that joins text values with a separator between them, such as a comma, a slash or a pipe. Use it to put several columns into one text field for an export, or to build a reference from parts such as entity, year and number.

Syntax and arguments

Example

An export needs one reference column built from the entity, the year and the sequence number of each journal, separated by hyphens.

let
    Source = Table.FromRecords({
        [Entity = "NW", Year = "2026", Sequence = "0415"],
        [Entity = "NW", Year = "2026", Sequence = "0416"]
    }),
    Combined = Table.CombineColumns(Source, {"Entity", "Year", "Sequence"},
        Combiner.CombineTextByDelimiter("-", QuoteStyle.None), "JournalRef")
in
    Combined

Each row now has a JournalRef such as "NW-2026-0415". The original three columns are removed by Table.CombineColumns, which leaves the new reference column.

Example: a second, different use

Joining a list of text values into one line for a note: Combiner.CombineTextByDelimiter(", ")({"Acme", "Bolt"}) returns "Acme, Bolt". For a plain list, Text.Combine does the same job with less setup.

Things to watch

In business terms

Building journal references, invoice keys, document numbers and CSV lines for an upload file is a common job. Keeping the reference format in one query means every file uses the same rule.

Related functions

All Power Query M functions · View as Markdown · M basics