Count Value from table comparison

[#1]

Two tables. Trying to get an expression to compare the two and give me the results of the ones missing a match

Qualify *;

Access: LOAD * INLINE [Group, Path

a,

b,

c,

d, ];

Unqualify *; Qualify *;

Type: LOAD * INLINE[Group, Type

a, REG

b, REG

d, SPEC];

Expression as I understand it would be something like:

count(distinct if(Type.Group<>Access.Group and Type.Type='Reg', Access.Group))

Doesn't work for me at all. I want it to look at all of fields in Type.Group and show me Access.Group that doesn't exist in Type.Group.

[marcus_sommer]

Without the qualify-stuff it would be easy with:

- Marcus

[Digvijay_Singh]

try this  -

Access:

Load Group, Path;

LOAD * INLINE [ Group, Path

a, "c:\dir1"

b, "c:\dir2"

c, "c:\dir3"

d, "c:\dir4" ];

Type:

Load Group as TempGroup, Type;

LOAD * INLINE [Group, Type

a, REG

b, REG

d, SPEC];

Notmatch:

Load Group as Group1, Path as Path1

Resident Access

Where Not exists(TempGroup,Group);