Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to concatenate a specified table? For example:
If my script is like:
table1:
LOAD a,b,c FROM...;
table2:
LOAD a,b FROM...;
If I do:
CONCATENATE LOAD a FROM..., it will automatically concatenate table2. What if I want to concatenate table1?
Thanks in advance!
table1:
LOAD a,b,c FROM...;
table2:
LOAD a,b FROM...;
concatenate(table1)
LOAD a,b FROM...;
table1:
LOAD a,b,c FROM...;
table2:
LOAD a,b FROM...;
concatenate(table1)
LOAD a,b FROM...;
you can write like this
Table1:
load * from table;
concatenate(Table1)
load * from table;
noconcatenate
table2:
load * from table;
Hi Yang,
Even if two or more tables do not have exactly the same set of fields, it is still possible to force Qlik Sense to concatenate the two tables. This is done with the concatenate prefix in the script, which concatenates a table with another named table or with the last previously created table.
Example:
LOAD a, b, c from table1.csv;
concatenate LOAD a, c from table2,csv;
The resulting internal table has the fields a, b and c. The number of records in the resulting table is the sum of the numbers of records in table 1 and table 2. The value of field b in the records coming from table 2 is NULL.
This will help you i guess...
Regards
PM