I'm sorry, but there's a little thing that is not working yet
My paths are written in this way
and so I'm using
SubField(FieldName, '/', -1) as Son4,
SubField(FieldName, '/', -2) as Son3,
SubField(FieldName, '/', -3) as Son2,
SubField(FieldName, '/', -4) as Son1,
SubField(FieldName, '/', -5) as Father.
The problem is that in this way the paths with less than 5 elements are giving their elements to the fith field, than to the fourth field ecc and the fields that are at the beginning are left blank
How can I solve this? Should I do something like a conditional loading that takes into account the number of '/' that it finds in the string?
Thanks a lot again!!!!