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

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

theisohn_f — Mon, 08 Apr 2024 10:00:22 GMT

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:

load

main_key,

sub_key

resident xyz;

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 — Mon, 08 Apr 2024 13:28:08 GMT

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 — Tue, 09 Apr 2024 06:17:33 GMT

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