I'm trying to concatenate two tables with same columns in data load editor, but it doesn't work. My script is like:
LOAD A, B;
select A, B from...where...;
SQLselect A, B from...where...;
How should I fix it?
Thanks in advance!
What is the output? Tables with identical field names will automatically concatenate in Qlik. Are you receiving a script error?
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?
I think, load the second table without table name it should be concatenated
Is you where condition returning any records ? Did you look at the log file to see if any records were returned from SQL?
Retrieving data ...