Forum Discussion

smpa01's avatar
smpa01
Community Champion
3 years ago
Solved

ANTI inside GENERATE?

Is it possible to factor an ANTI JOIN inside GENERATE. I am currently doing this     EVALUATE VAR __fact = DATATABLE ( "fact.fact", STRING, { { "a Messi" }, ...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    3 years ago

    How about this?

    res =
FILTER (
    __fact,
    ISEMPTY (
        FILTER (
            __exec,
            RIGHT ( [fact.fact], LEN ( [exec.name] ) ) = [exec.name]
        )
    )
)
AlexisOlson's avatar
AlexisOlson
Super User
3 years ago

How about this?

res =
FILTER (
    __fact,
    ISEMPTY (
        FILTER (
            __exec,
            RIGHT ( [fact.fact], LEN ( [exec.name] ) ) = [exec.name]
        )
    )
)