Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Table A
Load
A,
B,
C;
Sql Select
A,
B,
C
From Table 1
Concatenate (Table A)
Load
A,
B,
C;
Sql Select
A,
B,
C
From Table 2
Qualify*;
Unqualify "B";
Table A_New:
Load *
Resident Table A;
Drop Table Table A;
Both the table 1 & table2 has same column name.
Hi,
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 ?
Hi Youssef
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.
Hi Youssef
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
Load
A,
B,
C
'Table A' as Flag;
Sql Select
A,
B,
C
From Table 1
Concatenate (Table A)
Load
A,
B,
C
'Table B' as Flag;
Sql Select
A,
B,
C
From Table 2
Qualify*;
Unqualify "B";
Table A_New:
Load *
Resident Table A;
Drop Table Table A;
Run and share above output.
Regards,
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..