Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

routine file csv

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

10 Replies
micheledenardi
Specialist II
Specialist II

To give the correct answer we need some other details like:

1) Have these .csv files the same structure (columns) ?

2) Are these .csv files always present in your sales points folders or there is a task that delete old file every night ?

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

1) yes, they have the same columns

2) they are always present in my folders, from the opening date to now. So, the amount of data is high.

thanks

micheledenardi
Specialist II
Specialist II

MainTab:

Load

     *,

     'Sales Point 1' as SalesPoint

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

Concatenate(MainTab)

Load

     *,

    'Sales Point 2' as SalesPoint

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

yes, but when i recive a new file in the sales point folder 'n' is automatically added to qlikview?

Because i recive daily new files from sales point....

micheledenardi
Specialist II
Specialist II

Yes.

You have to create a load statement for each Sales point folder.

When a .csv files is added to these folders it's automatically (with document reload ) loaded in your analysis because with this type of load (with the asterisk) you are telling to Qlik something like: Load all files with .csv extension in this specific folder:

MainTab:

Load

    *,

    'Sales Point 1' as SalesPoint

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
micheledenardi
Specialist II
Specialist II

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

it doesn't work.... Qlik tells me that it's unable to open the 'C:\Sviluppo\68426', unable to find the specified file.

i try again:

MainTab:

Load

*,

'Name of the folder' as name of the folder

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

Anonymous
Not applicable
Author

Federica,

Do you want this scheduled load?

Not applicable
Author

Hi guys,

i'm managed to improve my qw file like Michele told me, but now i have another problem:

in my point of sales' folders i have different kind of .csv files and i only want those who are called like "TBVENDPC_idpointofsales_date". obviously they are as many as are the closing day of the cash.

how can i do?

thanks