PATH throws unexpected exception

Hey guys

A colleague and I experienced the same error and solved it the following way:

We found that one child's parent value was the same as the child's own value in the data source (Excel Sheet), as on Id 2 in the dummy example below:

Id | Child                   | Parent

1   | SomeValue          | AnotherValue

2   | ThirdValue           | ThirdValue

We changed the child value in the data source to something else, like:

Id | Child                   | Parent

1   | SomeValue          | AnotherValue

2   | ThirdValue1         | ThirdValue

Then we deleted the Path-column, reloaded the data and created the Path-column again.

Everything now works as expected.

Hope you guys can use this approach as well.

Best,

Kristian