Field Not Found After Concatenation

[Anonymous]

Hi to all

I just made a concatenation but unfortunately when I up load the data the NOT EXISTS(VenCodCliente, VenCodCliente) fields are missing:

Ventas:
LOAD
...,
... AS VenMes,
... AS VenCodCliente,
... AS VenNomCliente
FROM [Dropbox Ventas Inventarios];

CONCATENATE (Ventas)
LOAD
VenCodCliente,
VenNomCliente
FROM
[Clientes]
WHERE
NOT EXISTS(VenCodCliente, VenCodCliente) //the key for not adding duplicates in the CONCATENATE.
;

Any ideas?

[Marcos_rv]

Ventas:
LOAD
...,
... AS VenMes,
... AS VenCodCliente,
... AS VenNomCliente
FROM [Dropbox Ventas Inventarios];

TRY THIS:

CONCATENATE (Ventas)
LOAD
Code as VenCodCliente,
Name VenNomCliente
FROM
[Clientes]
WHERE
NOT EXISTS(VenCodCliente, Code) 
;

SALUDOS!!!

[kaushiknsolanki]

Hi,

Try this.

Where Not Exists(VenCodCliente);

If this doesnt work, reload without exists condition and check if the error is pointing to anything else or just exists condition.

Regards,

Kaushik Solanki

[Anonymous]

Hi

I just reload and it is the condition that you suggest... Any other idea?

Concatenate (Ventas)

LOAD
Code as VenCodCliente,
Name as VenNomCliente

FROM [lib://Clientes (qlikcloud_qlikid_aholguininflex)]
(html, utf8, embedded labels, table is @1) Where Not Exists(VenCodCliente);

[kaushiknsolanki]

Try the one solution which @Marcos_rv  gave.

Where not exists(VenCodCliente,Code);

Regards,

Kaushik Solanki

[Marcos_rv · Accepted solution]

LOAD
Code as VenCodCliente,
Name as VenNomCliente

FROM [lib://Clientes (qlikcloud_qlikid_aholguininflex)]
(html, utf8, embedded labels, table is @1) Where Not Exists(VenCodCliente,Code ); // here!!!!

ESTO SE HACE PORQUE TU SEGUNDA TABLA NO TIENE EL CAMPO CARGADO CON DICHO NOMBRE Y TUVISTE QUE RENOMBRAR.

saludos!!!

[Anonymous]

Mil gracias por tu ayuda!!!!!!