Compare 2 Fields and get the count

[vardhancse]

Hi,

Have one requirement:

• Have 2 tables with similar structure
• Need to compare ID fields from both the tables
• get the count of ID's not available in Fact2 when compared with Fact1

E.g:

the result should be 3

When comparing ID(Fact1) and Fact2.ID(Fact2) 3 records are not available in Fac2.

Fact1:

LOAD * INLINE [

    Region, Country, ID

    Asia, India, AsiaIndia

    Asia, Singapore, AsiaSingapore

    Asia, Malaysia, AsiaMalaysia

    US, USA, USUSA

    UK, London, UKLondon

    East, Dubai, EastDubai

    East, Saudi, EastSaudi

];

Qualify *;

Fact2:

LOAD * INLINE [

    Region, Country, ID

    Asia, India, AsiaIndia

    Asia, Malaysia, AsiaMalaysia

    US, USA, USUSA

    UK, London, UKLondon

];

Pls find the attached sample app for reference.

[vardhancse · Accepted solution]

Hi All

Tried using using Applymap() and was able to achieve the requirement