Combiner.CombineTextByRanges

D

Back to top

T

Back to top

#

Back to top

The M Code Behind the Power Query M function Combiner.CombineTextByRanges

What is Combiner.CombineTextByRanges?

The Combiner.CombineTextByRanges function is a Power Query M function that allows you to combine text values by specifying a range of characters to include in the combined text. This function is useful when you need to merge text values from multiple columns or rows into a single text value.

How does Combiner.CombineTextByRanges work?

The Combiner.CombineTextByRanges function takes three arguments:

How to use Combiner.CombineTextByRanges?

1. In Power Query, select the table you want to transform.

= Combiner.CombineTextByRanges({[First Name], [Last Name]}, {{0, Text.Length([First Name])}, {0, Text.Length([Last Name])}}, “, “)

The Combiner.CombineTextByRanges function is a powerful tool for manipulating and transforming text values in Power Query. It allows you to combine text values by specifying a range of characters to include in the combined text. We have explored the M code behind this function and how to use it to combine text values from multiple columns into a single column. With this knowledge, you can start using this function in your Power Query transformations to streamline your data cleansing process and make your data analysis more efficient.

Power Query and M Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)