Skip to main content
16-Pearl
September 25, 2018
Question

How to get the unique column values from 2 infotables

  • September 25, 2018
  • 2 replies
  • 1377 views

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.

 

2 replies

1-Visitor
September 25, 2018

Use RIGHT join instead of INNER on intersect snippet

Support
October 15, 2018

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