Forum Discussion

ruanctorres's avatar
ruanctorres
Frequent Visitor
9 years ago
Solved

Joining tables without primary key

Hi everybody,   Im trying to join tables with no primary keys. Is it possible?   For example:   Table 1:   Table 2:     A need a table result where for each day I have all the ...
Need Help
  • ruanctorres's avatar
    ruanctorres
    9 years ago

    Hi Lydia,

     

    Thanks for your time. In fact, I solved this problem creating a column in both tables, filling the rows with the same result, for example "1".

     

    Best regards.

dwscottjr's avatar
dwscottjr
New Member
2 years ago

If I have 2 queries and I want to join them without a key, I make a custom column in the first query that is the second query:

 

= Table.AddColumn(Source, "From Table 2", each #"Table2")