topic Re: Where Exists Renamed Field in QlikView

Where Exists Renamed Field

hvfalcao — Fri, 19 Feb 2016 13:34:42 GMT

Hi,

I'm trying to use where exists in some load script:

Pedido:

LOAD

IDPEDIDO,

IDPESSOA // this IDPESSOA is the client ID.

IDREVENDEDOR; // this IDREVENDEDOR is the dealer ID.

SQL SELECT

IDPEDIDO,

IDPESSOA,

IDREVENDEDOR

FROM PEDIDO;

Revendedor:

LOAD

IDPESSOA AS IDREVENDEDOR,

NMPESSOA AS NMREVENDEDOR,

WHERE EXISTS (IDREVENDEDOR)

// Here is the problem: If I choose "WHERE EXISTS (IDPESSOA)" it'll filter by IDPESSOA from table Pedido (that's not what I want, because it will load only the clients IDs. I need to filter all IDREVENDEDOR from table Pedido, witch will bring me only the dealers ID's.

SQL SELECT

IDPESSOA,

NMPESSOA

FROM PESSOA;

So... There is any way to apply Where Exists with renamed fields?

Thank You!

Re: Where Exists Renamed Field

sunny_talwar — Fri, 19 Feb 2016 14:22:00 GMT

Try this may be:

Pedido:

LOAD

IDPEDIDO,

IDPESSOA // this IDPESSOA is the client ID.

IDREVENDEDOR; // this IDREVENDEDOR is the dealer ID.

SQL SELECT

IDPEDIDO,

IDPESSOA,

IDREVENDEDOR

FROM PEDIDO;

Revendedor:

LOAD

IDPESSOA AS IDREVENDEDOR,

NMPESSOA AS NMREVENDEDOR,

WHERE EXISTS (IDREVENDEDOR, IDPESSOA)

SQL SELECT

IDPESSOA,

NMPESSOA

FROM PESSOA;

Re: Where Exists Renamed Field

hvfalcao — Fri, 19 Feb 2016 16:49:07 GMT

Sunny,

It works! Thank you!