Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.)
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.)