Inner keep load

[Holzi]

Hi Every one,

I'm currently working with the "inner keep load" command, but I'm not getting the result I expected.

// Variante 1
VTab1:
Load * resident Table1;
VTab2:
inner Keep load * resident Table2;
drop table Table1, Table2;

So I have Table1 and Table2. I load the data from these tables into VTab1 and VTab2 and both are connected to each other via the common field A. When I load the data, I only see VTab2.
Can someone please tell me what I'm doing wrong?

Best regards
Holzi

[Or · Accepted solution]

Rule of thumb - when using load * from Resident always use Noconcatenate Load, unless you're intentionally trying to create a single end table.

Not sure if that's your issue here, but that's where I'd start.