Forum Discussion

Ben-Dev's avatar
Ben-Dev
Icon for Helper II rankHelper II
4 years ago
Solved

Table.View - Handling NestedJoin + Expand

Hello,   I'm trying to build a Table.View that handles a Table.NestedJoin + Table.ExpandTableColumn sequence of operations.   let // returns a table that includes column "RelationshipColum...
Need Help
  • artemus's avatar
    artemus
    4 years ago

    This maps to:

    1. Table RenameColumns (if join columns have the same name)
    2. Table.Join
    3. Table.SelectColumns (if join columns have the same name)

    Note: A nested join using left outer will not result in any calls to the connector. It simply adds a virtual table column waiting to be expanded. Other join types will break folding, performing an expand column afterwards will unbreak folding.

Ben-Dev's avatar
Ben-Dev
Icon for Helper II rankHelper II
4 years ago

Thanks, lbendlin. I'm familiar with the general concept of Table.Views; but I'm not sure which handlers Table.NestedJoin + Table.ExpandTableColumns maps to.