Is it possible to join two Datasets, in the similar vein of Excel vlookup?

With the latest update, yes. Can't remember exactly how, but it should be in SA. However, I discovered that you can apparently only use fields from one of the two datasets at once in the UI. Which completely defeats the purpose of joining them. I guess for the first release of that option, they're only expecting you to use scripts or non-UI way to reference the joined dataset. It's irritating that the option is useless in the UI though.

Thanks @RJMNS Will look it up.

I just explored this the other day. Yeah, it does link 2 datasets but only in the Workbooks (pivot and chart but not tables). Also, I was expecting it to work like a vlookup but it didn't. I hope I'm just doing something wrong. For example, I have 2 datasets with the following fields: Dataset A: Employee Service Item Project Task Project Task Internal ID Dataset B: Project Task Internal ID Custom Rate Project Task Internal ID was my primary key. I added all the columns in the pivot. I noticed that it didn't do the vlookup based solely on primary key. Since Dataset B doesn't have access to Employee and Service Item, the pivot didn't match anything because those 2 are empty in Dataset B. It seems that I have to make all the fields I add to the pivot as primary keys but that's not always the case because the fields may not exist in the other dataset. Or maybe this is how relational database works? (I'm not a tech guy, sorry).

Were you able to add fields from both datasets A & B? When I tried it, as soon as I added a field from Dataset A, the fields from Dataset B disappeared and were no longer available to add. And vice versa. Maybe it was a bug.....

@RJMNS you're probably doing it in a Table? That's what happened when I tried it. Per documentation, Tables are not supported. Only Pivot and Chart are.

Yes I was using a table. I guess it's good it's supported somewhere, but it still seems dumb that they'd make it available on charts and pivots and not tables.