Question

I need help in using the join function in JQL

  • 11 June 2020
  • 1 reply
  • 56 views

Hello,

I'm trying to run this query:

function main() { 
return join(
Events({
from_date: "2020-04-10",
to_date: "2020-06-10"
}),
People(),
{
type:'inner',
selectors:[{event:"[Login] Log in success"}]
})
.groupByUser(function(state, events){
return events
})
}

The output is something like this:

[
{
"key": [
"sdssdfsdfsdfsdfsd"
],
"value": [
{
"distinct_id": "sdfsfsdfsdfsdfsdf",
"event": {},
"labels": [],
"user": {
"distinct_id": "sdfdsfsdfsfsfsdfdsf",
"labels": [],
"last_seen": 1589181171754,

It's not clear to me why I'm getting "event":{}

Why is there no event information?


1 reply

Hey there! I might have a better solution.. our new Lookup Tables are in closed Beta. Have you seen this? I think this will help you enrich your Mixpanel data better than joining tables in JQL. 

Reply