Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

All my queryes go to the same resyult table, am i missing something

Hello

I have one script  with  3 queryes , 

When i load de data i would expect to create c1, c2 and c3, but instad everything goes to c1,   What am I missing ?   (i have used QS but new with QV)

c1 << T_QUERY 13 lines fetched

c1 << T_QUERY 30 lines fetched

c1 << T_QUERY 45 lines fetched

This is part the script

c1:

load

CANT_QRY_1,

CANT_USERS;

sql select

CANT_QRY_1

CANT_USERS

where

CRR_ID_QRY = 1

;

c2:

load

CANT_QRY_2,

CANT_USERS;

sql select

CANT_QRY_2,

CANT_USERS

where

CRR_ID_QRY = 2

;

c3:

load

CANT_QRY_3,

CANT_USERS;

sql select

CANT_QRY_3

CANT_USERS

where

CRR_ID_QRY = 3

;

4 Replies
ogautier62
Specialist II
Specialist II

hi,

may be comma's missing in sql select?

CANT_QRY_1

CANT_USERS

Anonymous
Not applicable
Author

Hi Oliver

No, it is not the ','    i just missed it when i rewrote the example, but it exists in my real query

Thanks

Camilo

settu_periasamy
Master III
Master III

Are you sure, you are using the different field names with these 3 tables?

May be try to use 'No Concatenate' between those tables.

Anonymous
Not applicable
Author

Hello Settu

I added noconcatenate , and it woerked

Thanks!!