Forum Discussion

Gerald23's avatar
Gerald23
Icon for Helper I rankHelper I
5 years ago
Solved

Change column types dynamically

Hi Everyone,   I have an issue with changing column types in the Power Query Editor.  Normally i change them in the UI but this time my column names can change and there can be more or less columns...
Need Help
  • Jakinta's avatar
    Jakinta
    5 years ago

    Your Changed Type step should be:

     

    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",
      List.Transform(
          List.RemoveFirstN(
              Table.ColumnNames(Source),
              13
    ),
      each {_, Currency.Type}
    ))

     

Jakinta's avatar
Jakinta
Icon for Solution Sage rankSolution Sage
5 years ago

Your Changed Type step should be:

 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",
      List.Transform(
          List.RemoveFirstN(
              Table.ColumnNames(Source),
              13
    ),
      each {_, Currency.Type}
    ))

 

Gerald23's avatar
Gerald23
Icon for Helper I rankHelper I
5 years ago

Tested and this works thanks for the help 🙂