How to get the unique column values from 2 infotables

[vi1]

Hi,

I have 2 infotables.

How to filter the unique column values from 2 nd table compared to 1st table column values..

I have tried to use "Intersect" but its giving the same column values .

Example:

 first table columns: path, description

 second table columns: path, ThingName etc

if first table column path value is not matches the 2nd table column path, then return the 2nd table path.

Thank you in advance.

[CarlesColl]

Use RIGHT join instead of INNER on intersect snippet

[slangley]

Hi @vi1.

If the response provided by Carles answered your question, please mark it as the Accepted Solution for the benefit of others who may have the same question.

Regards.

--Sharon