Merge Queries

[LalaLee]

why I am able to merge queries from Table B to Table A but was unable to do so for Table A to Table B.

Meaning I merge Age column from Table B to Table A and wanted to merge Sch Attended from Table A to Table B I am unable to do so.  When I select Table B in the drop down, there is no preview show and then error.

[PwerQueryKees]

I guess you get something like a cyclic reference error.

You solve it by splitting your query for Table A in 2 parts.

1. The bit before the merge call it "A Before Merge" 
2. Then reference that query and do the merge (call it "A after Merge")

In query B you merge with the " A Before Merge" 

[bhanu_gautam]

@LalaLee , Can you share sample data for this