Need Help to combine

Hi athul00000 

You can create three blank queries in power query and put the following code to advanced editor

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jVXbbqMwEP2VUZ+7EoEUwqOBSbAwNrJNG9T2M/b/d4Zbw2VDHyIxsY/PxWP78/PlFCTRJQ7j+PLy+lOkVKivv0EQJsaiUNBYc0XnpNEaFc/sf9+v+wskp5CKWngr7/QRPp18uQRUVGiF88IhfUdP5ien6MzzWQzPPa/nDstNRcpOstZJTQD6DHo5i6XTB+MJj+dGGSs8ed0CJvq54CC0kMqNoSwWH3KYijCmwjWYS6F8N+byZH7E67mqA+nAlwhK1tKP8Sxgg8uxSAPWl1RAaepC2GKyHS1sJ8GjbWbKlNEFEqwtpNnDDAbmIqGiEQq9RzBXaETfHrvA3slcsEdvPHWVMqbaA6wMnR72EDJjnEcLuSJCCMfYn5kLpz2F3FiL+bizG9hKJsecU/N7+U6plKLBLWjqgLkI+3ZgBrLHfQGNUdKVUIhul3OZKbd5qzNirUSmEIY9+YXHaPZYYefgBH+YEU5jlz3jTPujWiHUCIW8SdqYXdQyHT53TWm8caUxfgvYJMMK28ZVUimpb2MeG5aVrfO+rXA8Bc/4ztMlAZmlgwBYtPl0qKM17arheFzjx4iUdY3W/Qe5Evy2FBw+7MP5QPDbLJguWxLrodLmQ2Fxwy16I5nHPXdrjdoD3lEp1PkuciU53pfMGb8dSI7Hyw8E9bypO+C4mrKjsJS5ddsVNrJ53OVCNeByOQo+YuWLJxNO5vDITX/GB2Q8XgppH7jiAy4+kCU9gL6E/jmMwYkr9rd3csDG46q9t7YDb4XU1PVb1IaQlyil88YOaeK7US23Ld+x/Ar0nqUuWucty7gcyOBxZ/jNoQNeSAE/h/AX6LRHXz30GEfE4Lgz0gH3/Q8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [parentId = _t, id = _t, name = _t, position = _t, level = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"parentId", "parentid"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"parentid", Int64.Type}, {"id", Int64.Type}, {"position", Int64.Type}, {"level", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([level] = 1))
in
    #"Filtered Rows"

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jVXbbqMwEP2VUZ+7EoEUwqOBSbAwNrJNG9T2M/b/d4Zbw2VDHyIxsY/PxWP78/PlFCTRJQ7j+PLy+lOkVKivv0EQJsaiUNBYc0XnpNEaFc/sf9+v+wskp5CKWngr7/QRPp18uQRUVGiF88IhfUdP5ien6MzzWQzPPa/nDstNRcpOstZJTQD6DHo5i6XTB+MJj+dGGSs8ed0CJvq54CC0kMqNoSwWH3KYijCmwjWYS6F8N+byZH7E67mqA+nAlwhK1tKP8Sxgg8uxSAPWl1RAaepC2GKyHS1sJ8GjbWbKlNEFEqwtpNnDDAbmIqGiEQq9RzBXaETfHrvA3slcsEdvPHWVMqbaA6wMnR72EDJjnEcLuSJCCMfYn5kLpz2F3FiL+bizG9hKJsecU/N7+U6plKLBLWjqgLkI+3ZgBrLHfQGNUdKVUIhul3OZKbd5qzNirUSmEIY9+YXHaPZYYefgBH+YEU5jlz3jTPujWiHUCIW8SdqYXdQyHT53TWm8caUxfgvYJMMK28ZVUimpb2MeG5aVrfO+rXA8Bc/4ztMlAZmlgwBYtPl0qKM17arheFzjx4iUdY3W/Qe5Evy2FBw+7MP5QPDbLJguWxLrodLmQ2Fxwy16I5nHPXdrjdoD3lEp1PkuciU53pfMGb8dSI7Hyw8E9bypO+C4mrKjsJS5ddsVNrJ53OVCNeByOQo+YuWLJxNO5vDITX/GB2Q8XgppH7jiAy4+kCU9gL6E/jmMwYkr9rd3csDG46q9t7YDb4XU1PVb1IaQlyil88YOaeK7US23Ld+x/Ar0nqUuWucty7gcyOBxZ/jNoQNeSAE/h/AX6LRHXz30GEfE4Lgz0gH3/Q8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [parentId = _t, id = _t, name = _t, position = _t, level = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"parentId", "parentid"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"parentid", Int64.Type}, {"id", Int64.Type}, {"position", Int64.Type}, {"level", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([level] = 2)),
    #"Merged Queries" = Table.NestedJoin(#"Filtered Rows", {"parentid"}, Query1, {"id"}, "Query1", JoinKind.LeftOuter),
    #"Expanded Query1" = Table.ExpandTableColumn(#"Merged Queries", "Query1", {"name"}, {"Query1.name"})
in
    #"Expanded Query1"

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jVXbbqMwEP2VUZ+7EoEUwqOBSbAwNrJNG9T2M/b/d4Zbw2VDHyIxsY/PxWP78/PlFCTRJQ7j+PLy+lOkVKivv0EQJsaiUNBYc0XnpNEaFc/sf9+v+wskp5CKWngr7/QRPp18uQRUVGiF88IhfUdP5ien6MzzWQzPPa/nDstNRcpOstZJTQD6DHo5i6XTB+MJj+dGGSs8ed0CJvq54CC0kMqNoSwWH3KYijCmwjWYS6F8N+byZH7E67mqA+nAlwhK1tKP8Sxgg8uxSAPWl1RAaepC2GKyHS1sJ8GjbWbKlNEFEqwtpNnDDAbmIqGiEQq9RzBXaETfHrvA3slcsEdvPHWVMqbaA6wMnR72EDJjnEcLuSJCCMfYn5kLpz2F3FiL+bizG9hKJsecU/N7+U6plKLBLWjqgLkI+3ZgBrLHfQGNUdKVUIhul3OZKbd5qzNirUSmEIY9+YXHaPZYYefgBH+YEU5jlz3jTPujWiHUCIW8SdqYXdQyHT53TWm8caUxfgvYJMMK28ZVUimpb2MeG5aVrfO+rXA8Bc/4ztMlAZmlgwBYtPl0qKM17arheFzjx4iUdY3W/Qe5Evy2FBw+7MP5QPDbLJguWxLrodLmQ2Fxwy16I5nHPXdrjdoD3lEp1PkuciU53pfMGb8dSI7Hyw8E9bypO+C4mrKjsJS5ddsVNrJ53OVCNeByOQo+YuWLJxNO5vDITX/GB2Q8XgppH7jiAy4+kCU9gL6E/jmMwYkr9rd3csDG46q9t7YDb4XU1PVb1IaQlyil88YOaeK7US23Ld+x/Ar0nqUuWucty7gcyOBxZ/jNoQNeSAE/h/AX6LRHXz30GEfE4Lgz0gH3/Q8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [parentId = _t, id = _t, name = _t, position = _t, level = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"parentId", "parentid"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"parentid", Int64.Type}, {"id", Int64.Type}, {"position", Int64.Type}, {"level", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([level] = 3)),
    #"Merged Queries" = Table.NestedJoin(#"Filtered Rows", {"parentid"}, Query2, {"id"}, "Query2", JoinKind.LeftOuter),
    #"Expanded Query2" = Table.ExpandTableColumn(#"Merged Queries", "Query2", {"name", "Query1.name"}, {"Query2.name", "Query2.Query1.name"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Query2",{"parentid", "id", "position", "level"}),
    #"Renamed Columns1" = Table.RenameColumns(#"Removed Columns",{{"name", "Topic"}, {"Query2.name", "Category"}, {"Query2.Query1.name", "Brand"}}),
    #"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"Brand", "Category", "Topic"}),
    #"Sorted Rows" = Table.Sort(#"Reordered Columns",{{"Brand", Order.Ascending}})
in
    #"Sorted Rows"

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.