Solved: loading a sample set of data - Qlik Community

Report Inappropriate Content · ‎2010-03-11

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

Miguel_Angel_Baeyens · ‎2010-03-11

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

Miguel_Angel_Baeyens · ‎2010-03-11

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.