Craft a binary load with sampled data

[Moritz]

Hi,

I'm pulling in various associated tables from another app, with help of a binary load.

While the "Sample" command works for single tables, i don't see this working for a binary load.

How would I create my own binary source with only a small sample of the data in the original app?

[pedrobergo · Accepted solution]

Hi @Moritz 

You cannot add SAMPLE prefix to BINARY because it is a hard copy from in-memory tables of an app, but you can add a load resident.

NoConcatenate
Sample XX
Load * Resident [Table];

Drop Table [Table];

[],

Pedro

[Moritz · Accepted solution]

Thanks, Pedro!

edit: this worked great!
As I have plenty of tables in this app, I'd need to loop through all of them.
The code below worked for me:

Binary [path];
FOR i = 0 to NoOfTables() - 1
LET vTableName = TableName(i);
NoConcatenate
Sample 0.01
LOAD * Resident [$(vTableName)];
Drop Table [$(vTableName)];
NEXT

Thanks!