Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

concatenate

I'm trying to concatenate two tables with same columns in data load editor, but it doesn't work. My script is like:

table1 :

LOAD A, B;

SQL

select A, B from...where...;

table2:

LOAD A,B;

SQL
select A, B from...where...;

How should I fix it?

Thanks in advance!

4 Replies
m_perreault
Contributor II

Re: concatenate

What is the output?  Tables with identical field names will automatically concatenate in Qlik.  Are you receiving a script error?

wanyunyang
Contributor

Re: concatenate

No script error, but something not showing in my pivot table.

If they concatenates, are they becoming one table? What is the new table's name?

zebhashmi
Valued Contributor

Re: concatenate

I think, load the second table without table name it should be concatenated

shivanandk
Contributor II

Re: concatenate

Is you where condition returning any records ?  Did you look at the log file to see if any records were returned from SQL?

Community Browser