Expression.Error: The column 'Dir.fieldB' of the table wasn't found.
How do I get at the joined table "Dir" within SelectColumns?
Forum Discussion
Solved
Accessing table and field from NestedJoin
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:
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.
3 Replies
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.
