Understanding Combo Data

Left joined combination data sets are very useful

Support avatar
Written by Support
Updated over a week ago

Flatly provides a number of "combo" or "combination" data sets which are two data sets combined.

Flatly generally uses the Left Join model for combining tables. You can read more about Left Join here:

Example: Organizations + Deals

If there are multiple (N) Deals relative to 1 Organization (as in Organizations+Deals) then in the context of 2 dimensional (tabular) data, Deals can only feasibly either be (1) extra columns, or (2) extra rows. (2) is the better option, and Organizations must be repeated (duplicated) for every N Deals.

Did this answer your question?