This function generates dependency path for a given node by searching with given dependency information
Input Parameters:
dependencies - Table with two columns source_id and target_idseparator - A string to concatenate the nodesstartList - The list of string to be searched as starting points to find its dependencies Return:
A
List of String formed by concatenation of dependent nodes separated by /
dependencies :
| source_id | target_id |
|---|---|
| A | B |
| B | C |
| D | C |
| E | D |
| C | F |
Invocation: fn_Dependency_Chain(dependencies, "/", {"F"})
Output:
| list |
|---|
| A/B/C/F |
| E/D/C/F |
You may refer to this example Excel workbook: fn_Dependency_Chain.xlsx
