Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ranajitsircar
New Contributor II

After concatenating not able to retrieve data from table 2

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.

Tags (1)
6 Replies
YoussefBelloum
Esteemed Contributor

Re: After concatenating not able to retrieve data from table 2

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 ?

ranajitsircar
New Contributor II

Re: After concatenating not able to retrieve data from table 2

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.

ranajitsircar
New Contributor II

Re: After concatenating not able to retrieve data from table 2

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

big_dreams
Contributor III

Re: After concatenating not able to retrieve data from table 2

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,

mohsinqlik
New Contributor III

Re: After concatenating not able to retrieve data from table 2

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.

YoussefBelloum
Esteemed Contributor

Re: After concatenating not able to retrieve data from table 2

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..



Community Browser