How to tag an interval of data according to a table
Hello,
I have a Table with distinct data like:
[AllData]:
Index
Information
1
a
2
b
3
c
4
d
5
e
6
f
7
g
8
h
9
i
10
j
I also have another table that states when somthing happened like:
[Situation]:
Index
Situation
0
X
2
Y
5
X
8
Z
What i need to do is join these two tables adding the "situation" to all index between the interval in its table, like the following:
[Result]:
Index
Information
Situation
1
a
X
2
b
Y
3
c
Y
4
d
Y
5
e
X
6
f
X
7
g
X
8
h
Z
9
i
Z
10
j
Z
Long story short, the situation reffers to all the next statements until a different situation appears.
I want to do this using the tables already loaded since the first and second table use some calculated information. I've been trying to use the Load Resident but haven't been succesful.
