KEEP creates pseudo-table?

PhilippZiemer — Fri, 01 Aug 2014 08:28:09 GMT

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

Re: KEEP creates pseudo-table?

Fri, 01 Aug 2014 08:31:06 GMT

Hi Philipp,

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

hope that helps

Joe