Forum Discussion
Solved
Get first date from another dataset using the Query Editor
Hi,
My source data table looks like this
Emp Code
DoJ
Report as at
A001
14-05-2020
01-06-2020
A002
02-03-2019
01-07-2020
A003
13-06-2019
01-08-2020
A...
In the query editor you can select your source, right click and pick reference. This will give you a new query that starts with your source. Then, on your new query, under transform pick group by and pick Emplyee Number with a new column of Min As At:
This should give you the data you are lookin for in a query you can join back to your other data.
In the query editor you can select your source, right click and pick reference. This will give you a new query that starts with your source. Then, on your new query, under transform pick group by and pick Emplyee Number with a new column of Min As At:
This should give you the data you are lookin for in a query you can join back to your other data.
Thank you. This works.