what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

[prahlad_infy]

Hello Sirs ,

what to put in Set expression to filter data from table 1st which is not present in table 2nd .

In attached data set i want to filter out those Entity which are not present in Status table

Table 1

Table 2

I want to filter out highlighted records of table 1 in separate column , because those entity are not present
in Order_owner column of table 2  , using set expression

Thank You

[jwjackso]

If you are filtering on entity, try

{<Entity=P(Order_Owner)>}

[vishsaggi · Accepted solution]

try like in your calculated dimensions.

= Aggr(IF(Entity <> Order_Owner, Entity), Entity)

Like use straight table with

Dim: = Aggr(IF(Entity <> Order_Owner, Entity), Entity)

      add other dimensions.

Expr: 1

Then in presentation tab just hide the expression 1.

[prahlad_infy]

THIS DIDNT WORK

Count({<Entity=P(Order_Owner)>}Entity)

[prahlad_infy]

Thank you Nagaraju ,

What if i am droping field from 2nd table

LOAD Order_Owner,

     Nbr,

     Status,

     AutoNumberHash256(Order_Owner&'|'&Nbr) as key

FROM

Data.xlsx

(ooxml, embedded labels, table is Status);

DROP Field Order_Owner ;

[prahlad_infy]

Can you suggest me any other alternative to Aggr(IF(Entity <> Order_Owner, Entity), Entity)

[vishsaggi]

Try on Purchase_Nbr like

= Aggr(IF(Purchase_Nbr <> Nbr, Entity), Entity)