Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.TransformColumnNames

Owen Duncan|Last Updated: 4/19/2018
|
1 Contributor

About

Transforms column names by using the given nameGenerator function. Valid options: MaxLength specifies the maximum length of new column names. If the given function results with a longer column name, the long name will be trimmed. Comparer is used to control the comparison while generating new column names. Comparers can be used to provide case insensitive or culture and locale aware comparisons. The following built in comparers are available in the formula language:

  • Comparer.Ordinal: Used to perform an exact ordinal comparison
  • Comparer.OrdinalIgnoreCase: Used to perform an exact ordinal case-insensitive comparison
  • Comparer.FromCulture: Used to perform a culture aware comparison

Table.TransformColumnNames(table as table, nameGenerator as function, optional options as nullable record) as table  

Example 1

Remove the #(tab) character from column names

Table.TransformColumnNames(Table.FromRecords({[#"Col#(tab)umn" = 1]}), Text.Clean)  
Column
1

Example 2

Transform column names to generate case-insensitive names of length 6.

Table.TransformColumnNames(Table.FromRecords({[ColumnNum = 1, cOlumnnum = 2, coLumnNUM = 3]}), Text.Clean, [MaxLength = 6, Comparer = Comparer.OrdinalIgnoreCase])

|Column|cOlum1|coLum2|
|----------|
|1|2|3|

© 2018 Microsoft