Accessing table and field from NestedJoin

[df555]

I have the following query in Excel Power Query:

= Table.SelectColumns(Table.NestedJoin(Table.Combine({TableA, TableB}),"PK",TableC,"PK","Dir",JoinKind.Inner),{"FieldA","Dir.FieldB"})

I get the following error:

Expression.Error: The column 'Dir.fieldB' of the table wasn't found.

How do I get at the joined table "Dir" within SelectColumns?

[edhans · Accepted solution]

You can try expanding the tables after the join @df555 then getting the columns. That is the easiest way.

= Table.SelectColumns(Table.ExpandTableColumn(Table.NestedJoin(Custom1, {"Digital Property"}, Table, {"Digital Property"}, "Table", JoinKind.LeftOuter), "Table", {"Custom"}, {"Custom"}),{"Digital Property", "Custom"})

Otherwise, you'll need to provide some data because I'm guessing what yours looks like.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[df555]

This works. I don't even need to use Table.SelectColumns. Thanks!

[edhans]

Excellent @df555 -glad I was able to assist.