Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Get Data from a Nested Table

Hello, 
within my data table I have several nested tables.
Using if conditions I want to check for different scenarios.
E.g. if [value_column] > [value_nestedtable1] then 1 else 0

I'm accessing the data within the nested table by using List.Max([nested_table][column_in_nestedtable]).
That works, however, it slows down my report significantly. 
The data within the nested tables are either numbers or dates.
Is there a better way to access the data within a nested table?


Thanks in advance,
Marco

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    You could instead use 

     

    Table.AggregateTableColumn(table as table, column as text, aggregations as list) as table

    and then do your comparison. So

     

    = Table.AggregateTableColumn(TableOrPriorStepName, {{"ColumnInNestedTable", List.Max, "NewColumnName"}})


    A lot of these table functions are very well optimized.

     

    --Nate

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Thank you for the answer.
    I think in that way I aggregate the nested table and only retrieve one value.
    Actually, I want to keep the whole nested table as I need it for further calculations.
    Then I have the same issue that getting data out of the nested tables slows down my report. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Do your nested tables result from a join, group, or something else.  Of course, if it's from grouping, you can add the Max aggregate in your group step.

     

    --Nate