Here is an odd one. If I use
[Data]:
Concatenate
Load *
Resident [Sample];
I get a completely different result to that if I use:
Concatenate([Data])
Load *
Resident [Sample];
Its as though the 1st statement applies some kind of Left Join principles to the [Data] table loaded in the script.?
Any ideas anyone?
Thanks
Moose