Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
df555
New Member

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:

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

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

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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

Excellent @df555 -glad I was able to assist.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors