Forum Discussion
Conditional Column with values from 2 tables
If you insist on doing this in the Query Editor I think you'll have to Merge the Queries
before you can compare the values - but we may have to check with ImkeF about this???
Look here
http://www.excelguru.ca/blog/2015/12/16/merge-tables-using-outer-joins-in-power-query/
and also
http://www.excelguru.ca/blog/2015/12/23/merge-tables-using-inner-and-anti-joins-in-power-query/
Hope this helps! :smileyhappy:
Agree with Sean.
I think that Ronnie7 's question has an unspoken implication in it: That the matching values from the 2 columns have a common row-indicator :-)
Which is normally not the row-number, but a matching attribute-value.
So as we don't have a data-model in the query-editor where the filters propagate, we need to join the tables on their common attributes in order to return meaningful data.
