Forum Discussion

sidyahmed_pbix's avatar
sidyahmed_pbix
Frequent Visitor
4 years ago
Solved

Change type of multiple columns

Hi there, I need to change the type of some columns in my table below  (all columns endswith z_matches) . How can i do in power query to change the type from boolean to text.  
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Insert this step where #"Changed Type" will need to be replaced with your previous step

    = Table.TransformColumnTypes(#"Changed Type",List.Transform(List.Select(Table.ColumnNames(#"Changed Type"), each Text.EndsWith(_,"z_matches")),each {_, type text}))
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Insert this step where #"Changed Type" will need to be replaced with your previous step

= Table.TransformColumnTypes(#"Changed Type",List.Transform(List.Select(Table.ColumnNames(#"Changed Type"), each Text.EndsWith(_,"z_matches")),each {_, type text}))