Hello all,
I am trying to get the peek of a date but only where the sort order of the activity is not null
ActivityTable:
Activity, Start, Finish
PG_DISC, 1/1/2021, 1/1/2022
A1,1/1/2022,2/2/2022
PG_1, 1/1/2022, 2/2/2022
A2, 2/2/2022,3/3/2022
Another Activity 3/3/2022,5/1/2022
PG_2, 2/2/2022, 3/3/2022
PG_Sub, 3/3/2022, 5/22/2022
SortOrderTable
load *
inline [
Activty, ActivitySort
PG_DISC,1
PG_1,2
PG_2,3
PG_SUB,4
I tried Peek, and understand I could create a table with just the values I need, but wonder if there is a better way.
Thank in Advance.....
