1 Reply Latest reply on Jun 24, 2014 10:11 PM by adam RSS
    michaelfr Creator

    Query Infotable

    Hello,

    Is it possible to query an infotable you have created? For example, I have a column with numbers in it. I want to sum those numbers up and group by an expression in another column.

    Thank you,

    Mike

      • Query Infotable
        adam Creator

        Hi Mike,

         

        For future reference, this is possible (see the

        Query()

        InfoTableFunction in the Snippets tab), but querying an InfoTable would not be the correct way to achieve your desired result. Instead, you'll want to use the

        Aggregate()

        Service in conjunction with

        DeriveFields()

        .


        You can reference section "05.01.03.12 InfoTableFunctions" of the Wiki for more information.


        Thanks,

        Adam