---
type: reference
area: knowledge
status: reference
date: 2026-05-03
created: 2026-05-03
updated: 2025-11-12
tags:
  - knowledge
---
### Function: `Filter_CAT_Data_Final`

```pseudo
FUNCTION Filter_CAT_Data_Final(CriteriaRow, CAT_Table)
    CREATE empty list MatchedRows

    FOR EACH CandidateRow IN CAT_Table DO
        SET IsMatch = TRUE

        FOR EACH Column DO
            SET CatValue = CandidateRow[Column]
            SET CriteriaValue = CriteriaRow[Column]

            IF CatValue == "*" THEN
                // Rule 1: CAT cell is a wildcard
                CONTINUE LOOP

            ELSE IF CriteriaValue == "" THEN
                // Rule 2: Blank Criteria acts as a wildcard
                CONTINUE LOOP

            ELSE IF CatValue != CriteriaValue THEN
                // Rule 3: Real mismatch → reject row
                SET IsMatch = FALSE
                BREAK COLUMN LOOP
            END IF
        END FOR

        IF IsMatch == TRUE THEN
            ADD CandidateRow TO MatchedRows
        END IF
    END FOR

    RETURN MatchedRows
END FUNCTION