Hi, if I have merge tables as new and then rather than the entire table I only want particular column / s , is there a way ?
so if if start with
Table.NestedJoin(merge, {"Item"}, MergeStart, {"Item"}, "New", JoinKind.LeftOuter)
i could then ;
Table.TransformColumns(
Table.NestedJoin(merge, {"Item"}, MergeStart, {"Item"}, "New", JoinKind.LeftOuter),
{"New",each _ [Customer] } )
but is there another way, I've included a couple of different approaches, to show what I was aiming for ,
Queries 'salesitem' salescustomer,
just interested to see if I can get at table columns withing merge. I have a couple of other questions but one at a time.
Richard.
Bookmarks