Forum Discussion
Conditional Column with values from 2 tables
Hello,
I need to create a conditional column in the query editor ( that is, before the data is being fed into the model), based on values from two tables.
I know that the conditional column is good for values from one tables.
What would be they way to do so for values from two different tables?
For example (if [table1.col_name] = "x" and [table2.col_name]="y" then...
Thanks!
2 Replies
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.
