Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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)}))
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)}))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.