Forum Discussion
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/query/40853228?&rcm.contentType=application/json&rcm.startIndex=1&oslc_cm.pageSize=5000")),
Source2= Json.Document(Web.Contents("https://rsq-tm.com/cqweb/oslc/repo/MYschema/db/CCP/query/38703771?&rcm.contentType=application/json&rcm.startIndex=1&oslc_cm.pageSize=5000")),
#"Converted to Table" = Record.ToTable(??? - Source1 union Source2 - ???)
Value = #"Converted to Table"{2}[Value]
etc......
thank you
Sure, use a Merge or Append query, the M function is Table.Join.
2 Replies
Sure, use a Merge or Append query, the M function is Table.Join.
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.
