Replace of column names

[Anonymous]

Hallo,

ich want to rename the colums names in     #"Geänderter Typ1" 

with the colum names of Table "z_dim_Messpunkte_SAP_namen":

This is my code:

let

    Quelle = Sql.Databases("idtsv069"),

    DB_QS = Quelle{[Name="DB_QS"]}[Data],

    dbo_v_SAP_ZDIM_MESSPUNKTE = DB_QS{[Schema="dbo",Item="v_SAP_ZDIM_MESSPUNKTE"]}[Data],

   #"Geänderter Typ" = Table.TransformColumnTypes(dbo_v_SAP_ZDIM_MESSPUNKTE,{{"MANDT", Int64.Type}}),

    #"Geänderter Typ1" = Table.TransformColumnTypes(#"Geänderter Typ",{{"MANDT", type text}}),

    #"Rename Columns" =  Table.RenameColumns(#"Geänderter Typ1", List.Zip( { Table.ColumnNames(#"Geänderter Typ1"), Table.ColumnNames(z_dim_Messpunkte_SAP_namen) } ) )

in

    #"Rename Columns"

I get the error:

A "RenameOperatios" is expected. What does that mean?

Where is the error?

[Vijay_A_Verma · Accepted solution]

Use this

1. if no. of columns a are more in 2nd table

#"Rename Columns" = Table.RenameColumns(#"Geänderter Typ1",List.Zip({Table.ColumnNames(#"Geänderter Typ1"),List.Range(Table.ColumnNames(z_dim_Messpunkte_SAP_namen),0,List.Count(Table.ColumnNames(#"Geänderter Typ1")))}))

2. If no. of columns are more in first table

#"Rename Columns" = Table.RenameColumns(#"Geänderter Typ1",List.Zip({List.Range(Table.ColumnNames(#"Geänderter Typ1"),0,List.Count(Table.ColumnNames(z_dim_Messpunkte_SAP_namen))),Table.ColumnNames(z_dim_Messpunkte_SAP_namen)}))