routine file csv

[#1]

Hello to all,

Problem: I have the .csv files I receive daily from the crates. Are located in different folders (subdivided by point of sale). I would like to create an automation that allows me to take the file daily and load it directly onto qlikview. Does anyone have any advice? thank you

- - -

Ciao a tutti,

problema: ho dei file .csv che ricevo giornalmente da delle casse. si trovano in cartelle differenti (suddivise per punti vendita).

Vorrei creare un automatismo che mi permetta di prendere giornalmente il file e lo carichi direttamente su qlikview.

qualcuno ha dei consigli?

grazie

[micheledenardi]

Hi Federica,

you have to change the loads from:

Load *

From *.csv (txt, codepage is 1252, no labels, delimiter is '\t', msq);

to

Load *

From TBVENDPC_idpointofsales_date*.csv (txt, codepage is 1252, no labels, delimiter is '\t', msq);

Doing this QlikView load all files with .csv extension and which start with TBVENDPC_idpointofsales_date.