Simplifying Power Query

Hi,

In the attached sheet, I have following queries, just trying to make it simpler in just one query. Any Help Please

= Table.NestedJoin(#"Table 3", {"Stock Invested in"}, #"Table 3 (3)", {"Stock Invested in"}, "Table 3 (3)", JoinKind.FullOuter)

= Table.ExpandTableColumn(Source, "Table 3 (3)", {"Stock Invested in", "Sector", "Sector Total", "Value(Mn)", "% of Total Holdings", "1M Change", "1Y Highest Holding", "1Y Lowest Holding", "Quantity", "1M Change in Qty", "M-Cap", "GroupName"}, {"Table 3 (3).Stock Invested in", "Table 3 (3).Sector", "Table 3 (3).Sector Total", "Table 3 (3).Value(Mn)", "Table 3 (3).% of Total Holdings", "Table 3 (3).1M Change", "Table 3 (3).1Y Highest Holding", "Table 3 (3).1Y Lowest Holding", "Table 3 (3).Quantity", "Table 3 (3).1M Change in Qty", "Table 3 (3).M-Cap", "Table 3 (3).GroupName"})


= Table.SelectColumns(#"Expanded Table 3 (3)",{"Stock Invested in", "Sector", "% of Total Holdings", "Table 3 (3).% of Total Holdings"})

= Table.SelectRows(#"Removed Other Columns", each ([#"Table 3 (3).% of Total Holdings"] <> null) and ([#"% of Total Holdings"] <> null))


= Table.TransformColumnTypes(#"Filtered Rows",{{"% of Total Holdings", Percentage.Type}, {"Table 3 (3).% of Total Holdings", Percentage.Type}})

check this

Please Login or Register  to view this content.

and use code tags in your posts

[CODE] your code here [/CODE]

I want to use only table 3 and table 3(3) to get same results

all-in-one single query

with table 3 and table 3(3) only

Please Login or Register  to view this content.

May I please request you to incorporate the query in the attached file for me to learn please

here is your previous file from post#1

.

.

I suggest to read Learn Power Query