Help

[panipat1990]

Hi sir,

     How to load multiple csv file in qlikview like excel.Please Help me.

[sunny_talwar · Accepted solution]

May be check out these links

QlikView - Loading Data From Multiple Files - YouTube‌

Loading Multiple Excel Sheets Dynamically along with file name and sheet name‌

Load Multiple excel sheets using For loop

[Kushal_Chawda]

all your CSV files are having same number of column and having same name?

see this, this should work for CSV as well

Dynamically Loading Multiple Excel Files

[panipat1990]

Hi sir,

This code work only For loading multiple excel file not multiple csv file.. Please help me for loading csv file. i have 40 to 50 csv file..

[trdandamudi]

Try like this:

LOAD * FROM Filename*.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[tamilarasu]

You can replace xls to csv in the script.  You can find many threads in the forum. Here is one ,  https://community.qlikview.com/thread/200874

[panipat1990]

Hi,

Is this possible in Loading multiple csv file or not.Please help me for guiding me for loading multiple csv file

[avinashelite]

yes, its possible check this

loop through to load all files from a folder and its subfolders?

[panipat1990]

Hi Sunny,

When i am using this code for loading csv file then it is not working..

[sunny_talwar]

Can you share the script you have tried thus far?