KEEP creates pseudo-table?

[PhilippZiemer]

Hello community,

I have a table "Customers" containing IDs and Names. I have another table "Keys" containing just IDs which I want to use to reduce table Customers.

RIGHT KEEP (Customer)

LOAD DISTINCT ID

RESIDENT Keys;

This always produces a table "Keys-1" containing the part

LOAD DISTINCT ID

RESIDENT Keys;

I could now drop this table. But I really wonder why it is created and how I could use the code correctly in order to avoid that.

Thanks and best

Philipp

[#2 · Accepted solution]

Hi Philipp,

keep will retain separate tables, you are looking for a join instead. It's also worth looking at this thread

Understanding Join, Keep and Concatenate

hope that helps

Joe