Path reverse lookup

Is there any way to achieve a reverse look up that returns the memeber position on the path?

 

I have this

 

| rowNum | pathString       | individiualValue |
|--------|------------------|------------------|
| 1      | 6000|5000|4000   | 6000             |
| 1      | 6000|5000|4000   | 4000             |
| 2      | 8000|9000|7000   | 1000             |
| 3      | 8000|9000|7000   | 8000             |

 

 

I want to end up with this

 

| rowNum | pathString       | individiualValue | position |
|--------|------------------|------------------|----------|
| 1      | 6000|5000|4000   | 6000             | 1        |
| 1      | 6000|5000|4000   | 4000             | 3        |
| 2      | 8000|9000|7000   | 1000             |          |
| 3      | 8000|9000|7000   | 8000             | 1        |

 

 

I can currently achieve it with this

 

Table = 
VAR baseTbl =
    DATATABLE (
        "rowNum", INTEGER,
        "pathString", STRING,
        "individiualValue", STRING,
        {
            { 1, "6000|5000|4000", "6000" },
            { 1, "6000|5000|4000", "4000" },
            { 2, "8000|9000|7000", "1000" },
            { 3, "8000|9000|7000", "8000" }
        }
    )
VAR modTbl =
    SUMMARIZE ( baseTbl, [rowNum], [pathString] )
VAR lookupTbl =
    GENERATE (
        modTbl,
        ADDCOLUMNS (
            GENERATESERIES ( 1, PATHLENGTH ( [pathString] ) ),
            "ind", PATHITEM ( [pathString], [Value], TEXT )
        )
    )
VAR res =
    GENERATEALL (
        baseTbl,
        VAR ky1 = [rowNum]
        VAR ky2 = [pathString]
        VAR ky3 = [individiualValue]
        RETURN
            SELECTCOLUMNS (
                FILTER ( lookupTbl, [rowNum] = ky1 && [pathString] = ky2 && [ind] = ky3 ),
                "position", [Value]
            )
    )
RETURN
    res

 

 But is there a built-in syntax available to tackle this or any other optimized way?

AlexisOlson  CNENFRNL