4 Comments

  • ADIELDAR's avatar
    ADIELDAR
    Microsoft Employee
    You can convert the table to string or Json like this:

    let tbl2dynamic_fl=(tbl:(*))

    {

        toscalar(tbl

        | extend pa = pack_all()

        | summarize make_list(pa))

    }

    ;

    let tbl1 = datatable(name:string, value:long) [

    'A', 1,

    'B', 2,

    'C', 3]

    ;

    print s=tbl2dynamic(tbl1)

    s

    [
    {
    "name": "A",
    "value": 1
    },
    {
    "name": "B",
    "value": 2
    },
    {
    "name": "C",
    "value": 3
    }
    ]

Recent ideas