Power Query Nested join to bring single column as list

Hello,
After a nested join is is possible in the code, not the expand aggregate options, to select just one column as a list,


so i can have a join ;
Table.NestedJoin( #"Added Index", "Index", N ,"Dday", "NEW", JoinKind.LeftOuter )

and then use transform column;

Please Login or Register  to view this content.

or just use addcolumn and select rows ;

Please Login or Register  to view this content.

So can nested join bring in a list ? I've attached the above examples as they probably show the end result better,

I was thinking along the the lines of addcolum ;

Please Login or Register  to view this content.

but this only works for a many to one side lookup.

Richard

I was hoping there was going to be a part of Nested join that allowed me to access the column as a list, but
that's a pretty consolation prize.

But yes it was what I meant. Thanks.

Richard.