Power Query; Transform column vs column type

[dicken]

Hi,
Just wondered if someone can give me a bit more information on ;
TableTransfromcolumntypes and table.transformcolums, they both seem to do the same thing;

Table.TransformColumns(  Source , { {"One", Text.From }} )
 Table.TransformColumnTypes ( Source , {{ "One", type text}} )

I've not really used them and wondered where one might be preferable over the other?

Richard.

 

[RoryA]

Although they can do the same things, transformcolumns can do a lot more than just changing types; you can actually alter the source data as well.

 

[dicken]

Although they can do the same things, transformcolumns can do a lot more than just changing types; you can actually alter the source data as well.

Thank, yes, I'd only really looked at ms docs.

Richard.