Forum Discussion
Helper IColumnNames with Datatypes
Hello MBreden Melanie
find herewith enclosed an example how this could work out. The easy task to extract the columnnames, but I don't know how you thought how to detect the correct type for every column. But maybe you get an idea how it could work out
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlXSUTKxMDQyBtKmSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Number = _t, Date = _t, Currency = _t]), ColumnNames = Table.ColumnNames(Source), Types = {type number, Int64.Type, Currency.Type}, Zip = List.Zip({ColumnNames, Types}), AdaptTypes = Table.TransformColumnTypes(Source, Zip) in AdaptTypesCopy paste this code to the advanced editor to see how the solution works
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Helper IHello Jimmy,
thank you for your answer!
Just right, I need a nested list of ColumnNames and data types to insert into the function.
But I don't know how to create it 🙄
Can you give me an example?
Melanie
Community ChampionHello MBreden Melanie
find herewith enclosed an example how this could work out. The easy task to extract the columnnames, but I don't know how you thought how to detect the correct type for every column. But maybe you get an idea how it could work out
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlXSUTKxMDQyBtKmSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Number = _t, Date = _t, Currency = _t]),
ColumnNames = Table.ColumnNames(Source),
Types = {type number, Int64.Type, Currency.Type},
Zip = List.Zip({ColumnNames, Types}),
AdaptTypes = Table.TransformColumnTypes(Source, Zip)
in
AdaptTypes
Copy paste this code to the advanced editor to see how the solution works
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy