You need to sign in to do that
Don't have an account?
Eli Bach
How to join multiple matches by using earliest/smallest match in Einstein Analytics (Wave)
I am trying to join a dataset which has multiple matches, see below for an example:
Dataset A
Org Id
Org1
Org2
Org3
Dataset B
EA Id, Org Id, Date
EA1, Org1, 1/1/2016
EA2, Org1, 1/1/2017
EA3, Org2, 6/6/2017
EA4, Org3, 8/1/2017
In this example, I would like to join EA Id and Date in Dataset B to Dataset A by Org Id. However, there are multiple matches for Org1. I would like to only join either the earliest or smallest value from Dataset B (EA1, 1/1/2016) to Dataset A. The resulting dataset should be:
Dataset A
Org Id, EA Id, Date
Org1, EA1, 1/1/2016
Org2, EA3, 6/6/2017
Org3, EA4, 8/1/2017
Is this possible?
Thanks
Dataset A
Org Id
Org1
Org2
Org3
Dataset B
EA Id, Org Id, Date
EA1, Org1, 1/1/2016
EA2, Org1, 1/1/2017
EA3, Org2, 6/6/2017
EA4, Org3, 8/1/2017
In this example, I would like to join EA Id and Date in Dataset B to Dataset A by Org Id. However, there are multiple matches for Org1. I would like to only join either the earliest or smallest value from Dataset B (EA1, 1/1/2016) to Dataset A. The resulting dataset should be:
Dataset A
Org Id, EA Id, Date
Org1, EA1, 1/1/2016
Org2, EA3, 6/6/2017
Org3, EA4, 8/1/2017
Is this possible?
Thanks