Skip to main content
P
ptc-62921441-Visitor
1-Visitor
June 24, 2014
Question

Query Infotable

  • June 24, 2014
  • 1 reply
  • 2354 views

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

    1 reply

    A
    adamtrainer5-Regular Member
    5-Regular Member
    June 25, 2014

    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



    Terms & ConditionsAccessibility statement