Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is it possible to factor an ANTI JOIN inside GENERATE. I am currently doing this
EVALUATE
VAR __fact =
DATATABLE (
"fact.fact", STRING,
{
{ "a Messi" },
{ "aaa Messi" },
{ "ababa Pele" },
{ "ababan Diego" },
{ "xyz Crisitiano" },
{ "yyy Ronaldo" },
{ "Messi aaa" }
}
)
VAR __exec =
DATATABLE (
"exec.name", STRING,
{
{ "Messi" },
{ "Crisitiano" },
{ "Ronaldo" }
}
)
VAR res =
FILTER (
__fact,
NOT ( [fact.fact] )
IN SUMMARIZE (
GENERATE (
__exec,
FILTER (
__fact,
VAR one =
LEN ( [exec.name] )
VAR two =
RIGHT ( [fact.fact], one )
RETURN
two = [exec.name]
)
),
[fact.fact]
)
)
RETURN
res
I want to avoid
Solved! Go to Solution.
How about this?
res =
FILTER (
__fact,
ISEMPTY (
FILTER (
__exec,
RIGHT ( [fact.fact], LEN ( [exec.name] ) ) = [exec.name]
)
)
)
How about this?
res =
FILTER (
__fact,
ISEMPTY (
FILTER (
__exec,
RIGHT ( [fact.fact], LEN ( [exec.name] ) ) = [exec.name]
)
)
)
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |