Forum Discussion

MR2001's avatar
MR2001
Icon for Helper II rankHelper II
10 years ago
Solved

Combine data from two different sources in the same query?

  Is it possible to merge data from two different data sources within the same query, something like: Source1 = Json.Document(Web.Contents("https://rsq-tm.com/cqweb/oslc/repo/MYschema/db/CCP/qu...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Sure, use a Merge or Append query, the M function is Table.Join.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Sure, use a Merge or Append query, the M function is Table.Join.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
10 years ago

Table.Join is equivalent to SQL-JOINS (with all options as well!).

What you need here is Table.Combine({Source1, Source2}) (or Append if you do it via the UI). This is the equivalent to the SQL-UNION.