concatenate

[wanyunyang]

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!

[m_perreault]

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

[wanyunyang]

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]

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

[shivanandk]

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