Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear:
I have an existential doubt when loading a table in my model QlikView.
I want to load a table like this:
Order | Creation Date | Creation Time | Type |
---|---|---|---|
150211669 | 01/07/2016 | 8:34:52 | FR |
150211670 | 01/07/2016 | 8:45:17 | FR |
150211671 | 01/07/2016 | 9:00:57 | NU |
150211672 | 01/07/2016 | 9:01:01 | AM |
150211694 | 01/07/2016 | 9:24:37 | FR |
150211694 | 01/07/2016 | 9:24:38 | CC |
150211706 | 01/07/2016 | 9:44:43 | FR |
150211706 | 01/07/2016 | 9:44:43 | AM |
But I need to be loaded in this way:
Order | Creation Date | Creation Time | Type |
---|---|---|---|
150211669 | 01/07/2016 | 8:34:52 | FR |
150211670 | 01/07/2016 | 8:45:17 | FR |
150211671 | 01/07/2016 | 9:00:57 | NU |
150211672 | 01/07/2016 | 9:01:01 | AM |
150211694 | 01/07/2016 | 9:24:37 | FR |
150211706 | 01/07/2016 | 9:44:43 | FR |
I try to explain.
An order can have records of a type or many
if a request has two or more different types and one of them is FR,
that all other records are removed leaving only the belonging to FR,
if does not have any record with FR type, it is the same.
I hope you understood my problem
Beforehand thank you very much.
-----------------------------------------------------------------------------------------------------------------------------------
Estimados:
Tengo una duda existencial al momento de cargar una tabla en mi modelo QlikView.
Deseo cargar una tabla similar a esta:
Pedido | Fecha Creación | Hora Creación | Tipo |
---|---|---|---|
150211669 | 01/07/2016 | 8:34:52 | FR |
150211670 | 01/07/2016 | 8:45:17 | FR |
150211671 | 01/07/2016 | 9:00:57 | NU |
150211672 | 01/07/2016 | 9:01:01 | AM |
150211694 | 01/07/2016 | 9:24:37 | FR |
150211694 | 01/07/2016 | 9:24:38 | CC |
150211706 | 01/07/2016 | 9:44:43 | FR |
150211706 | 01/07/2016 | 9:44:43 | AM |
Pero necesito que se cargue de esta manera:
Pedido | Fecha Creación | Hora Creación | Tipo |
---|---|---|---|
150211669 | 01/07/2016 | 8:34:52 | FR |
150211670 | 01/07/2016 | 8:45:17 | FR |
150211671 | 01/07/2016 | 9:00:57 | NU |
150211672 | 01/07/2016 | 9:01:01 | AM |
150211694 | 01/07/2016 | 9:24:37 | FR |
150211706 | 01/07/2016 | 9:44:43 | FR |
Trataré de explicarlo.
Un pedido puede tener registros de un Tipo o de muchos
si un pedido posee dos o mas tipos distintos y uno de ellos es FR,
que se eliminen los demás registros dejando solamente el perteneciente a FR,
si no posee ningún registro con tipo FR, que quede igual.
Espero que se haya entendido mi problema
De antemano muchas gracias.
Mensaje editado por: Felipe Gonzalez
Try this:
Table1:
LOAD
Order,
[Creation Date],
[Creation Time],
Type
FROM
...source_table...
WHERE
Type = 'FR'
;
CONCATENATE (Table1)
LOAD
*
FROM
...source_table...
WHERE
NOT EXISTS(Order)
;
Follow your guide at the end but I was more when reading the database, thank you very much
- - -
al final segui tu guía pero me fui mas al momento de leer la base de datos, muchas gracias
Note: Edited by Community Moderator to include English translation as a courtesy.