Incremental loading multiple files

airobles — Fri, 22 Jun 2018 21:26:10 GMT

Hello

How can I upload several files and update by adding information to different fields?

Examples, I have 30 files of the month where I have to add elements such as minutes, data, etc, for a key. In the end I need the grouped qvd to do other analyzes

Example Load:

CARGA_ARCHIVO_CONSUMO:

LOAD @1 AS NUM_TELEFONO,

@4 AS FECHA_ALTA,

MAX(@5) AS DIAS_CONSUMO,

SUM(IF(@6='BYTEGR',@7))/1024/1024 AS MBYTES,

SUM(IF(@6='MINF',@7))/60 AS MINUTOS,

SUM(IF(@6='SMSGR',@7)) AS SMS,

SUM((IF(@6='BYTEGR',@7))/1024/1024)*0.0344 AS COSTE_MBYTES,

SUM((IF(@6='MINF',@7))/60)*0.0398 AS COSTE_MINUTOS,

SUM(IF(@6='SMSGR',@7)*0.0049) AS COSTE_SMS

FROM

(txt, codepage is 1252, no labels, delimiter is '|', msq)

GROUP BY @1,@4;

STORE CARGA_ARCHIVO_CONSUMO INTO D:\RUTA\CARGA_ARCHIVO_CONSUMO.QVD;

DROP TABLE CARGA_ARCHIVO_CONSUMO;

The script is grouping and summarizing but by file inserting 30 clusters. what I need is only one that contains all the grouped of the 30 files

I hope you can help me, because by doing it this way I take up a lot of space and resources, Tanks

Re: Incremental loading multiple files

petter — Sun, 24 Jun 2018 10:10:41 GMT

So what is not working for you - it the "example" script working at all or not?

It seems that you load multiple files in the ADQ_EVENT*.txt .... it that where the 30 files come in or do you have 30 different folders/directories with multiple files in each?

topic Incremental loading multiple files in QlikView

Incremental loading multiple files

Re: Incremental loading multiple files