Forum Discussion
Ben-Dev
Helper II
Helper IITable.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...
This maps to:
- Table RenameColumns (if join columns have the same name)
- Table.Join
- 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-DevHelper II
Helper IIHi artemus,
Thank you for this list of handlers.
Could you tell me which handler (or sequence of handlers) a Table.NestedJoin call followed by a Table.ExpandTableColumn maps to?
Thank you!
artemus
Microsoft Employee
Microsoft EmployeeThis maps to:
- Table RenameColumns (if join columns have the same name)
- Table.Join
- 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.