Joining the data with specific feilds

I have used Join tool (Join be Specific Fields) to merge the both the data from 2 different input and get the output as expected,

However my concern is where do i find the data in Input 2 which are not in Input 1 are excluded?

Do I need to draw different workflow to find that? or should i use any other before use the Join tool to identify the unique value in each input?

Regards

Mahadev

Input

Dynamic Processing

Join

Data Investigation

Database Connection

Behavior Analysis

Accepted answers

RolandSchubert

Hi Mahadev,

just have a look at the R anchor of JOIN tool (J = matched records, L = records only in Input1, R = records only in Input2).

Best regards

Roland

All comments

RolandSchubert

Hi Mahadev,

just have a look at the R anchor of JOIN tool (J = matched records, L = records only in Input1, R = records only in Input2).

Best regards

Roland

Mahadevaswamyb

Thank you very much for timely reply and can we join Excluded (records only on Input 1 or 2) data with original set again by using Join or Union ?

RolandSchubert

Yes, you can use UNION to join the excluded data again.

UNION "L" & "J" is comparable to a "LEFT OUTER JOIN" in SQL (i.e. records with Join field in both data sets and excluded records from Input1)

UNION "R" & "J" is comparable to a "RIGHT OUTER JOIN" in SQL (i.e. records with Join field in both data sets and excluded records from Input2)

UNION "L" & "J" & "R" is comparable to a "FULL OUTER JOIN" in SQL (i.e. records with Join field in both data sets and excluded records from Input1 & Input2)

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703