topic Re: Concatenante two tables in QlikView

Concatenante two tables

Fri, 02 Jan 2015 10:43:58 GMT

Hi and happy new year eveybody !!!!!

I have an issue.. i want to concatenante two fields with the "where not exists" function like that:

Client:

load

N°

from DATA$Customer;

concatenante

load N°

where not exists ( N°,N°(Number of the DATA$Customer table?)

from HEOR$Customer;

The problem is i want to say to qlikview concatenante all the N° of the DATA$Customer and all the N° of HEOR$Customer which were not exists in the DATA$Customer table and save the result in the N° field.

But i don't know how to do this,

anyone can help me???

Thanks a lot!!!

Re: Concatenante two tables

rubenmarin — Fri, 02 Jan 2015 10:50:35 GMT

Hi sab, it should work like you are doing it:

concatenante

load N°

where not exists (N°,N°)

from HEOR$Customer;

This example also works, it wouldn't load the second client Nº 1:

LOAD * INLINE [

Nº, client

1, Client 1

2, Client 2

];

Concatenate LOAD * Inline [

Nº, client

1, client 2-1

3, Client 3

] Where not Exists(Nº, Nº);

Re: Concatenante two tables

SunilChauhan — Fri, 02 Jan 2015 10:55:29 GMT

[DATA$Customer temp]:

load

N°

from DATA$Customer;

Test:

load N°

where not exists ( [N°],[N°]

from HEOR$Customer;

drop table [DATA$Customer temp];

[DATA$Customer]:

load

N°

from DATA$Customer;

concatenate

Load N°

resident Test;

drop table Test;

hope this helps

Re: Concatenante two tables

Fri, 02 Jan 2015 11:34:23 GMT

Thanks a lot guys!

It's works!