Table.CombineColumnsToRecord

Understanding the Table.CombineColumnsToRecord Function

The Table.CombineColumnsToRecord function is used to combine multiple columns in a table into a single record. The resulting record is created by combining the values of the selected columns, with the column names used as the record field names. Here’s the basic syntax of the function:

The function takes three arguments:

– table: The table containing the columns to be combined.

– columnNames: A list of column names to combine.

– newColumnName: The name of the new column to create.

Here’s an example of how to use the function:

In this example, we start with a table containing three columns: Column1, Column2, and Column3. We use the Table.CombineColumnsToRecord function to combine these columns into a new column called Combined.

Examples of Using the Table.CombineColumnsToRecord Function

Example 1: Combining Columns with a Delimiter

Let’s say we have a table containing first names and last names, and we want to combine these columns into a single column with a delimiter between them. We can use the Table.CombineColumnsToRecord function with a custom delimiter to achieve this task. Here’s how:

In this example, we start with a table containing two columns: Column1 (first names) and Column2 (last names). We use the Table.CombineColumnsToRecord function to combine these columns into a new column called Name. We then add a custom delimiter (“, “) between the first and last names using the Table.AddColumn function.

Example 2: Combining Columns with a Space

Let’s say we have a table containing a person’s first name, middle initial, and last name, and we want to combine these columns into a single column with a space between them. We can use the Table.CombineColumnsToRecord function with a space delimiter to achieve this task. Here’s how:

In this example, we start with a table containing three columns: Column1 (first names), Column2 (middle initials), and Column3 (last names). We use the Table.CombineColumnsToRecord function to combine these columns into a new column called Name. We then add spaces between the first name, middle initial, and last name using the Table.AddColumn function.

The Table.CombineColumnsToRecord function is a powerful tool for combining multiple columns into a single record in Power Query. By understanding the M code behind this function and its syntax, you can easily create new columns that consolidate data and simplify your workflow. With examples of how to use this function in different scenarios, you can start using it right away to streamline your data analysis.

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

Upcoming Courses

Contact Us