Hello there! I'm trying to see if there's a way to join multiple data sources (3-4) that do not share a common key, like a user ID.
I use Stripe, Google AdWords, HubSpot, and a Call Tracking application. All support REST APIs, but each of the applications has their own user IDs for each of my clients. I want a dashboard that joins all of their data into a single place, but since there are no common keys, it's not a simple join.
I know how I might do this in a BI tool by creating a new table with the keys and then joining my datasets to that, but can something like this be done in Klip?