Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe in this way:
temp: load sub_key resident abc;
A: load main_key, sub_key, exists(sub_key) as flag resident xyz;
Maybe in this way:
temp: load sub_key resident abc;
A: load main_key, sub_key, exists(sub_key) as flag resident xyz;
Seems to be exactly what I was looking for. Thanks a lot for your support