
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Field Not Found After Concatenation
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?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try the one solution which @Marcos_rv gave.
Where not exists(VenCodCliente,Code);
Regards,
Kaushik Solanki

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mil gracias por tu ayuda!!!!!!
