Pathcontains to check with values from a column of another table
Hello everyone, I'm stuck with a calculated column. I want to check if an ID from a column in a table called Table1 is contained in the PATH in a table called Table2. And if yes return the related DESCRIPTION of the ID that matched the CONTAINSPATH. Exemple below: Table1 Table 2: The column "DESCRIPTION FROM Table1" will be my calculated column. I have an idea of how we can bring the final result: Will be a if condition on if PATHCONTAINS on my PATH in Table2 in the column ID of the Table2, if true return the description related to the ID that match with the PATHCONTAINS else return "Not find". Thanks in advance for your support !
