I want to make a field called ACheck that will output either Missing or Ok.
However I'm not sure how to get the logic to apply to a whole group to return the correct data.
Sample Data:
IDField Description Checknumber Part
A1001 John ABC 656 A CALD
A1001 John ABC 756 D CALD
A1001 John ABC 856 T CALD
A1002 Mark NULL CALD
A1002 Mark NULL CALD
A1002 Mark NULL CALD
A1003 Luke ABC 482 A CALD
A1003 Luke NULL CALD
A1003 Luke ABC 912 T CALD
A1004 Matt NULL CALD
A1004 Matt ABC 777 H PALD
A1004 Matt NULL CALD
The logic needs to be as follows:
IF the Checknumber IS NULL for ALL IDField (NOT just NULL in some)
AND ignore where Part = PALD
Expected Output:
IDField Description Checknumber Part ACheck
A1001 John ABC 656 A CALD Ok
A1001 John ABC 756 D CALD Ok
A1001 John ABC 856 T CALD Ok
A1002 Mark NULL CALD Missing
A1002 Mark NULL CALD Missing
A1002 Mark NULL CALD Missing
A1003 Luke ABC 482 A CALD Ok
A1003 Luke NULL CALD Ok
A1003 Luke ABC 912 T CALD Ok
A1004 Matt NULL CALD Missing
A1004 Matt ABC 777 H PALD Missing
A1004 Matt NULL CALD Missing
As you can see even though the A1004 group aren't all NULL's they are still getting classed as missing because i want to ignore PALD.
