Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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