Importing table with predefined data type from metadata

Solution code:

let
    types = [Text = Text.From, #"Decimal number" = Number.From, #"Whole number" = Int64.From],
    type_table = Table.Group(
        Excel.CurrentWorkbook(){[Name="ColumnDataTypes"]}[Content], 
        "TableName", 
        {
            "transform", 
            (x) => List.Zip(
                {
                    x[ColumnName], 
                    List.Transform(x[ColumnDataType], (w) => Record.FieldOrDefault(types, w, each _))
                }
            )
        }
    ),
    type_record = Function.Invoke(Record.FromList, List.Reverse(Table.ToColumns(type_table))),
    result = ((table_name) => Table.TransformColumns(
        Record.Field(#shared, table_name), 
        Record.Field(type_record, table_name), 
        null, 
        MissingField.Ignore
    )) ("PetTable")
in
    result

approach taken from https://www.excelforum.com/office-365/1433993-power-query-to-import-column-data-types-from-table.html 

Best,
Jacek