Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Append column names in nested table from value of another column

Hello everyone, could I please get help from  anyone on how to rename all column names from the tables in "Custom" column and append them with the value from column "Code"
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    2 years ago

    Use this code. Replace #"Grouped Rows" with your previous step name

    = Table.FromRecords(Table.TransformRows(#"Grouped Rows", (r)=> [Code = r[Code], Custom = Table.TransformColumnNames(r[Custom], (x)=>x&Text.From(r[Code]))]))
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Use this code. Replace #"Grouped Rows" with your previous step name

= Table.FromRecords(Table.TransformRows(#"Grouped Rows", (r)=> [Code = r[Code], Custom = Table.TransformColumnNames(r[Custom], (x)=>x&Text.From(r[Code]))]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you Vijay, it worked great.

    Is there a way to rename columns that name which contains specific text, let's say rename columns that contains "abc" in the header only

    • dufoq3's avatar
      dufoq3
      Icon for Community Champion rankCommunity Champion
      2 years ago

      Hi Anonymous, check this. Remove ", Comparer.OrdinalIgnoreCase" from the code if you want case sensitive check.

       

      let
    Source = #table(type table[Code=Int64.Type, Custom=table], {
        {6100, #table({"Column10", "Test abc 1", "Column20"}, {{1,2,3}})},
        {6200, #table({"Column10", "Test abc", "A_Abc_B"}, {{4,5,6}})}
    }),
    Ad_Renamed = Table.AddColumn(Source, "Renamed", each Table.RenameColumns([Custom], 
        [ a = List.Select(Table.ColumnNames([Custom]), (x)=> Text.Contains(x, "abc", Comparer.OrdinalIgnoreCase)),
          b = List.Zip({ a, List.Transform(a, (x)=> x & Text.From([Code])) })
        ][b]),
    type table)
in
    Ad_Renamed