Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
3 years ago
Solved

transform a column type based on column name

Hello, I need to change the column type of my table based on a text they contain.   So I have my list with all the columns that should be converted to the type Currency.Type: filter_type_names ...
Need Help
  • Jakinta's avatar
    Jakinta
    3 years ago

    Hi Valeria,

     

    does this work?

     

    FinalTransformedColumns = Table.TransformColumnTypes( #"Removed Columns", List.Transform( filter_type_names, each {_,Currency.Type}))
Jakinta's avatar
Jakinta
Solution Sage
3 years ago

Hi Valeria,

 

does this work?

 

FinalTransformedColumns = Table.TransformColumnTypes( #"Removed Columns", List.Transform( filter_type_names, each {_,Currency.Type}))
ValeriaBreve's avatar
ValeriaBreve
Post Partisan
3 years ago

Jakinta yes it does! Thank you so much! I had tried a List.Zip with "Currency.Type" as second argument for every column, but powerBI would not accept it not recognizing the text input "Currency.Type" as a type.

Thanks again!