Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change_Data_type

Hello, please help.    I need to change the column type to letter and number simultaneously. Like on picture. How can I do this?        Thank you for your help. 
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    7 years ago

    Hi,

     

    An easy way to get the generic any type would be to change the data type of the column and replace the type in the code like below for an example

     

    = Table.TransformColumnTypes(#"Removed Columns",{{"Column1", Int64.Type}})

    To

    = Table.TransformColumnTypes(#"Removed Columns",{{"Column1", type any}})

     

     

Gordonlilj's avatar
Gordonlilj
Solution Sage
7 years ago

Hi,

 

An easy way to get the generic any type would be to change the data type of the column and replace the type in the code like below for an example

 

= Table.TransformColumnTypes(#"Removed Columns",{{"Column1", Int64.Type}})

To

= Table.TransformColumnTypes(#"Removed Columns",{{"Column1", type any}})