Discussion board where members can get started with Qlik Sense.
I have two table. Table 1 & Table B 2 am fetching the data from SQL database. While I do a concatenation data from table 2 is not retrieving. I am doing this in Qliksense.
Below is my script.
From Table 1
Concatenate (Table A)
From Table 2
Resident Table A;
Drop Table Table A;
Both the table 1 & table2 has same column name.
because you're tables have exactly the same structure, they will automatically concatenate, even if you don't explicitly concatenate them (using concatenate)
did you try to load only table2 to see if there is data on it ?
If I put concatenate or nothing it would not make a difference it will at the end concatenate. I tried loading only table 2 data is coming then.
If I put concatenate or nothing it would not make a difference it will at the end concatenate. I tried loading only table 2 data is coming then
How did you come to know that data is not coming from table2 ??
can you elaborate
try below to debug
Add flag field in your script.
'Table A' as Flag;
'Table B' as Flag;
Run and share above output.
Table 2 has got appended to table 1.
So you will be able to see that there is only one table i.e table 1 in data model viewer.
that's what i said above..
it's strange, it should work..
are you setting errormode to 0 ? your table name Table A_New will not work the way you wrote it above..