Not Exists - Object Level

[Anonymous]

I have a column Clients in the Fact table and there's another list of Clients which is ExClients provided in Excel file. I need to show in one tab on the front-end the list which should be Clients - ExClients i.e. those Clients that do not exist in ExClients.

If it was across the board, I could have used Not Exists in script but need to keep the original Clients' list as it and only show the subtracted list on one object/tab.

Any suggestions?

[MayilVahanan]

Hi

Are you looking like this?

[fred_s]

With the load of Ex-Clients, you could add an extra field like this:

ex:

Load * ,
'1' as Ex
;

Load *
FROM Ex-Clients;

and in your table use "Ex <> 1".

[Clever_Anjos]

1) Create a flag into Fact Table

2) Using the OnActivate Sheet trigger set a selection using Select in Field action

[Anonymous]

Clever Anjos,

I was thinking along the same lines as Mayil Vahanan Ramasamy and Fred Schonenberg but could you elaborate your approach ?

[fred_s]

Hi Arsalan,

See attachment...

This way you can select Ex Clients with Ex = 1 or Ex <> 1 for the Non-Ex-Clients 🙂

[Clever_Anjos · Accepted solution]

You can use as Fred Schonenberg suggested, or like this

ExClient:
LOAD * Inline
[
ClientID,Client1
1,XX
2,YY
];
Test:
LOAD 
*,  
Exists(Client1,Client) as Flag
Inline
[
ClientID,Client
1,XX
2,YY
3,ZZ
4,BB
];

doing this you can

count({1<Flah={"-1"}>}Client) count clients that are present into ExClient

count({1<Flah-={"-1"}>}Client) count clients that are NOT present into ExClient

CliCl iententClClien