Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aminehaddar
Contributor II
Contributor II

limit load of 2 files

Hello,

CLIENT:

LOAD *,$(DATE_S) AS DATE

FROM '..\'CLIENT.qvd'(qvd);

for i=2 to $(a)

    let DATE_SITUATION = FieldValue('DATE', $(i));

          CONCATENATE(CLIENT)

           LOAD

           * $(DATE_S) AS DATE  FROM 'CLIENT2.qvd'(qvd);

next;

The objective is to have 5000 customers from the first file, and 5000 from the second one.

And it is necessary to concatenate the tables.

Any suggestions please?

I used rowNo() > 5000 and the result is 5000 customers from the first file.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try with first 5000

This is from Qlik help

The First prefix to a Load or Select (SQL) statement is used for loading just a set maximum number of records from the data source, regardless of its length.

The syntax is:

first n ( loadstatement | selectstatement )

where:

n is an arbitrary expression which evaluates to an integer indicating the maximum number of records to be read.

Examples:

First 10 LOAD * FROM abc.csv;

First (1) SQL SELECT * FROM Orders; (Note: The parenthesis is allowed but not required.)

View solution in original post

1 Reply
maxgro
MVP
MVP

try with first 5000

This is from Qlik help

The First prefix to a Load or Select (SQL) statement is used for loading just a set maximum number of records from the data source, regardless of its length.

The syntax is:

first n ( loadstatement | selectstatement )

where:

n is an arbitrary expression which evaluates to an integer indicating the maximum number of records to be read.

Examples:

First 10 LOAD * FROM abc.csv;

First (1) SQL SELECT * FROM Orders; (Note: The parenthesis is allowed but not required.)