Voters 17
-
-
-
-
-
-
-
- + 11 voters
-
-
-
-
-
-
M
-
I
-
P
-
-
Merging / Blending / Joining data (cross object)
- Planned
- Subscribe
 |
Emil (Databox) |
DESCRIPTION: Ability to combine, blend or join data from different sources, objects, tables and visualize all this in a user-friendly way.
Users would:
- First choose a Data Source or Dataset they want to merge with another Data Source or Dataset
- Align the two sources by selecting a unique identifier (column available in both sources)
- Select what columns you’d want to merge
- Specify how you want the columns to be merged: a) Include only first match (no new rows are created) or include all matches (create new rows for each match) b) Exclude rows that do not match (Inner Join), include rows for unmatched values from primary source (Left Join), or include rows for unmatched values from secondary source (Right Join).
It will also be possible to export data from Datasets.
USE CASE: Combine data from different data sets / tables like Customers from Source 1 and Orders from Source 2. Use unique identifiers to match rows and then visualize what customer placed which order, calculate conversions, and track the customer journey across different systems.
LET US KNOW WHAT YOU THINK!: We might develop this feature in the future. We encourage you to upvote it if you find it valuable and leave a comment with feedback and insight into what objectives you feel this feature could help you with. Getting more feedback upfront will help us better align the feature with our users' needs.
DISCLAIMER: The image mockup shared in this post is for illustrative purposes only and does not represent the final product. The final version of the product may differ from the mockup.
Activity Newest / Oldest
Gary Magnone
highly anticipated so I can build tables with multiple custom metrics with consolidated rows.
Emil (Databox)
Status changed to: Planned