lookupvalue same table

frankee_gee

Board Regular
Help would be appreciated

trying to use lookupvalue to return an "end" date which is determined by table[type]

table[ID]
-will be duplicated for each table[type]
-each table[type] can be duplicated for each table[ID]

table[date]


table[type]
-"s" - start
-"c" - continue
-"g" - going
-"e" - end

idtypedate expected result stop date
22s1/1/20192/17/2019
22c1/12/20192/17/2019
22c1/23/20192/17/2019
22e2/15/20192/17/2019
22e2/17/20192/17/2019
88s1/26/20191/31/2019
88e1/31/20191/31/2019

<tbody>
</tbody>



thank you in advance.
 

peter789

Board Regular
Load the table to PQ.
Duplicate it.
In the copy filter by type ="e".
Group by id return max of date.
Merge this query back with original joined on id; expand on the max date.

Peter
 

Some videos you may like

This Week's Hot Topics

Top