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