Skip to content
Test-area LKA
Share
Explore

Recursive lookup example

An example using lookup to make an recursive parent/ child tree. See explanation below the table:


DB_Projects
0
Search
Project Name Indented
Project Name
Parent Folder
Project Name DB
Level
Project Name Full
Project Text
RowID
1
Finance
Finance
/ Finance
1
/ Finance

Open
1
2
HR
HR
/ HR
1
/ HR

Open
4
3
Change structure
Change structure
/ HR
@ / HR
/ Change structure
2
/ HR / Change structure

Open
5
4
Hire new CFO
Hire new CFO
/ HR
@ / HR
/ Hire new CFO
2
/ HR / Hire new CFO

Open
6
5
Office
Office
/ Office
1
/ Office

Open
7
6
Rebuild room B
Rebuild room B
/ Office
@ / Office
/ Rebuild room B
2
/ Office / Rebuild room B

Open
10
7
New desks
New desks
/ Office / Rebuild room B
@ / Office / Rebuild room B
/ New desks
3
/ Office / Rebuild room B / New desks
d
Open
11
8
Reorganize cable
Reorganize cable
/ Office / Rebuild room B
@ / Office / Rebuild room B
/ Reorganize cable
3
/ Office / Rebuild room B / Reorganize cable
test text
Open
12
9
Repair tables
Repair tables
/ Office
@ / Office
/ Repair tables
2
/ Office / Repair tables

Open
8
10
Security
Security
/ Office
@ / Office
/ Security
2
/ Office / Security

Open
13
11
Replace locks
Replace locks
/ Office / Security
@ / Office / Security
/ Replace locks
3
/ Office / Security / Replace locks

Open
14
12
Production
Production
/ Production
1
/ Production

Open
3
There are no rows in this table
How it shows up in a selector:
/ Finance


You only fill in the green Columns “Project Name” and “Parent Folder”, and you only need the Project Name DB (Yellow),to use the logic.
The rest columns is just to make it easier to work with and visualise the data.

The recursive part happens as “Parent Folder” lookup “Project Name DB”, which again aggregates it’s full value from it’s parent “Parent Folder”

It’s just one lookup and simple formulas. It’s very fast and easy to set up. “Project Name Indented” is just an example, and for this type of processing, “Level” and “RowID” might come in handy.


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.