Change data type of all columns in a table

[yg1982]

Hi,

I need to transform the data type of all columns in a table (the number and the name of the columns can change in the future).
In another post I found the following solution:

let Source = Excel.CurrentWorkbook(){[Name="YourTable"]}[Content],

LSTHeaders = Table.ColumnNames(Source),

HowMany = List.Count(LSTHeaders),

Transformation = Table.TransformColumnTypes( Source, Table.ToRows(Table.FromColumns({LSTHeaders, List.Repeat({type number}, HowMany )}))) 

It works fine but I don't know how to apply "en-US" data format.
I tried the following but didn't work:

Transformation = Table.TransformColumnTypes( Source, Table.ToRows(Table.FromColumns({LSTHeaders, List.Repeat({
{type number}, "en-US"}, HowMany )})))

Any help? Thanks

[Anonymous]

try this

Transformation = Table.TransformColumnTypes( Source, Table.ToRows(Table.FromColumns({LSTHeaders, List.Repeat({
{type number}}, HowMany )})), "en-US")

[Anonymous · Accepted solution]

or this (not tested)

Transformation = List.Accumulate(LSTHeaders,Source, (s,c)=>Table.TransformColumnTypes( s, {c,type number}, "en-US")

[yg1982]

Thanks a lot

[Anonymous]

Transformation = Table.TransformColumnTypes(Source, List.Transform(LSTHeaders,each {_, type number}),"en-US")

or this

[Anonymous]

Thanks Rocco, this works like a charm