topic Re: Select data from two tables in QlikView

Select data from two tables

Mon, 26 Jan 2026 18:19:17 GMT

Hi Guys,

i have two tables like these:

A	B
1	Y
2	Y
3	N

A
1
4
5

I'd like to have something like this:

A	B
1	Y
2	Y
3	N
4
5

Can you help me please?

Re: Select data from two tables

krishnacbe — Tue, 28 Mar 2017 13:47:26 GMT

Hi,

Simple Load will create the result table. Try below code.

Table1:
LOAD * INLINE [
A, B
1, Y
2, Y
3, N
];
Table2:
LOAD * INLINE [
A
4
5
];

Re: Select data from two tables

aarkay29 — Tue, 28 Mar 2017 13:55:19 GMT

Use Join statement to join the table

Table:
LOAD * INLINE [
A, B
1, Y
2, Y
3, N
];
Join (Table)
LOAD * INLINE [
A
4
5
];

Re: Select data from two tables

Tue, 28 Mar 2017 14:03:53 GMT

Values 4 and 5 in column A should have "N" in column B of table RESULT; Sorry, i didn't specify it

Re: Select data from two tables

krishnacbe — Tue, 28 Mar 2017 14:06:56 GMT

You can use below expression in Script or Chart to replace the Null values with N

if(isnull(B) or Len(B)=0,'N', B)

Re: Select data from two tables

aarkay29 — Tue, 28 Mar 2017 14:07:46 GMT

If you have no specific logic to specify N or Y and just want to give 'N' for the second table then

Table:
LOAD * INLINE [
A, B
1, Y
2, Y
3, N
];
Join (Table)

LOAD A, 'N' as B;

LOAD * INLINE [

A
4
5
];

Re: Select data from two tables

Tue, 28 Mar 2017 14:14:51 GMT

In your answers you make:

LOAD * INLINE [
A, B
1, Y
2, Y
3, N
];
Join (Table)
LOAD * INLINE [
A
4
5
];

I can't delete value 1 from second table

Re: Select data from two tables

Tue, 28 Mar 2017 14:16:28 GMT

i'have to make a full outer join from first and second table and then make a condition to set null values in column B (table of results) as "N"

Re: Select data from two tables

aarkay29 — Tue, 28 Mar 2017 14:19:56 GMT

Table:

LOAD * INLINE [
A, B
1, Y
2, Y
3, N
];
Join (Table)
LOAD * INLINE [
A
4
5
];

Noconcatenate

Load A,

If(Isnull(B),'N',B) as B

resident Table;

Drop Table Table;

Re: Select data from two tables

krishnacbe — Tue, 28 Mar 2017 14:31:57 GMT

I agree with Aar Kay Solution to fix in Script.

Re: Select data from two tables

Tue, 28 Mar 2017 14:41:04 GMT

Thank you so much; i made a mistake:

Operatori:

LOAD CF_OPERATORE as OPERATORE,

TIPOLOGIA_OPERATORE

FROM

(biff, embedded labels, table is [Scarica foglio di lavoro$]);

join(Operatori)

LOAD EVENTO_CREATO_DA as OPERATORE;

SQL SELECT * FROM TBL_EVENTI E

WHERE E.EVENTO_CREATO_DA NOT IN (SELECT operatore FROM tb_sospensioni S WHERE S.inizio_sospensione <= E.EVENTO_CREATO_IL AND S.fine_sospensione >= E.EVENTO_CREATO_IL);

NoConcatenate

LOAD OPERATORE,

IF(IsNull(TIPOLOGIA_OPERATORE),'NO_CCR',TIPOLOGIA_OPERATORE) as TIPOLOGIA_OPERATORE

/*IF(TIPOLOGIA_OPERATORE <>'',TIPOLOGIA_OPERATORE, 'NO_CCR') as TIPOLOGIA_OPERATORE*/

Resident Operatori;

Drop Table Operatori;