Forum Discussion
Look up value in different row and return row in Query editor
Hello DavidBlockAU,
You can try the following steps:1. Create a duplicate of the table. Go to that duplicate table.
2. Go to Transform > Group By. Enter JobNo as Grouping, New column name - 'StartDate', Operation - 'Min' & Column - 'TargetDate'. Click on OK.
3. Go to the original table > Merge Queries. Merge original and duplicate table with JobNo column.4. Expand the column and select only 'StartDate. You will have your column.
Hope this helps.
Resident RockstarHello DavidBlockAU,
You can try the following steps:
1. Create a duplicate of the table. Go to that duplicate table.
2. Go to Transform > Group By. Enter JobNo as Grouping, New column name - 'StartDate', Operation - 'Min' & Column - 'TargetDate'. Click on OK.
3. Go to the original table > Merge Queries. Merge original and duplicate table with JobNo column.
4. Expand the column and select only 'StartDate. You will have your column.
Hope this helps.
Can't believe I didn't think to do this, already have 3 merges in the model! Thanks for the suggestion rajulshah!