Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading a sample set of data

Does anyone know if there is a command that would allow me to load just a sample set of data?

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hello,

Depending on how is your data source strctured, it could be as easy as doing something like

SampleTable:LOAD Field1, Field2, RecNo() WHERE RecNo() <= 100; SQL SELECT Field1, Field2 FROM DataSource;


Another option is to create a table loading just the dates existing on your data source, and then loading, with a very similar code, some records for each date.

View solution in original post

1 Reply
Miguel_Angel_Baeyens

Hello,

Depending on how is your data source strctured, it could be as easy as doing something like

SampleTable:LOAD Field1, Field2, RecNo() WHERE RecNo() <= 100; SQL SELECT Field1, Field2 FROM DataSource;


Another option is to create a table loading just the dates existing on your data source, and then loading, with a very similar code, some records for each date.