How to create a flag for not existing dataset in keep load

[theisohn_f]

Hi,

First of all, I am new to the Community, so please excuse if my question isn't appropriate in any way.

I am loading two table like this:

A:

load

main_key,

sub_key

resident xyz;

B:

left keep (A)

load sub_key

resident abc;

Now I want a flag in table A which shows if a corresponding value is existing in table B or not.

Thank you very much for your support.

[marcus_sommer · Accepted solution]

Maybe in this way:

temp: load sub_key resident abc;

A: load main_key, sub_key, exists(sub_key) as flag resident xyz;

[theisohn_f]

Seems to be exactly what I was looking for. Thanks a lot for your support