topic Re: Help in QlikView

Help

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

Hi sir,

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

Re: Help

sunny_talwar — Tue, 10 May 2016 09:39:43 GMT

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

Re: Help

Kushal_Chawda — Tue, 10 May 2016 09:40:34 GMT

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

Re: Help

panipat1990 — Tue, 10 May 2016 10:01:41 GMT

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..

Re: Help

trdandamudi — Tue, 10 May 2016 10:06:41 GMT

Try like this:

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

Re: Help

tamilarasu — Tue, 10 May 2016 10:07:24 GMT

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

Re: Help

panipat1990 — Tue, 10 May 2016 11:07:17 GMT

Hi,

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

Re: Help

avinashelite — Tue, 10 May 2016 11:36:44 GMT

yes, its possible check this

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

Re: Help

panipat1990 — Tue, 10 May 2016 12:03:32 GMT

Hi Sunny,

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

Re: Help

sunny_talwar — Tue, 10 May 2016 12:04:56 GMT

Can you share the script you have tried thus far?

Re: Help

panipat1990 — Tue, 10 May 2016 12:13:23 GMT

let vExcelFilePath = 'C:\Users\admin\Desktop\excel';

let vQVDFilePath='C:\Users\admin\Desktop\excel\QVD';

SUB CreateQVDFromAllExcelFiles(vPath)

FOR EACH vFileExtension IN 'csv'

FOR EACH vFile IN FILELIST(vPath & '\*.' & vFileExtension);

ODBC CONNECT32 TO [Excel Files;DBQ=$(vFile)];

Temp:

LOAD *;

SQLtables;

DISCONNECT;

Data:

LOAD * INLINE [

junk ];

FOR i = 0 TO NOOFROWS('Temp')-1

LET vSheetName = PURGECHAR(PURGECHAR(PEEK('TABLE_NAME', i, 'Temp'), CHR(39)), CHR(36));

CONCATENATE(Data)

LOAD *,

FILEBASENAME() AS FileName,

'$(vSheetName)' AS Sheet_name

FROM $(vFile)(ooxml, embedded labels, table is [$(vSheetName)]);

NEXT i

DROP TABLE Temp;

DROP FIELD junk;

// When there is blank sheet in excel an extra Field 'A' is created.

LET vCheckA= IF(FIELDNUMBER('A','Data')>0,'1','0'); // If variable value is 1 means Field A is created due to blank sheet in excel

IF $(vCheckA) =1 THEN

DROP FIELD A;

ELSE

LET vCheckA =NULL();

ENDIF

LET i= NULL();

LET vSheetName=NULL();

NEXT vFile

NEXT vFileExtension

STORE Data into $(vQVDFilePath)\FullData.qvd;

//DROP Table Data;

LET vFileExtension=NULL();

LET vFile =NULL();

END SUB

CALL CreateQVDFromAllExcelFiles('$(vExcelFilePath)');

exit Script;

Re: Help

sunny_talwar — Tue, 10 May 2016 12:27:21 GMT

I don't see any variable vSheetName getting created above

Re: Help

panipat1990 — Tue, 10 May 2016 12:35:33 GMT

but when i use this code for loading excel then no problem is facing...

Re: Help

sunny_talwar — Tue, 10 May 2016 12:37:14 GMT

Can you may be share the logfile for when you try to run the csv file?

Re: Help

panipat1990 — Tue, 10 May 2016 12:50:05 GMT

Where this option to attach file in reply box

Re: Help

sunny_talwar — Tue, 10 May 2016 12:51:39 GMT

Check here: Uploading a Sample

Re: Help

trdandamudi — Tue, 10 May 2016 12:52:45 GMT

You click on reply and then on the top right hand side corner click on 'Use advanced editor". You will see "Attach" in the bottom right hand side corner.

Re: Help

panipat1990 — Fri, 13 May 2016 07:57:23 GMT

Hi Sunny,

Actually, i want to Store final application(All Sheets Used In Application) in qvd.Is it possible in qlikview.Please guide me.if is it possible.

Re: Help

Chanty4u — Fri, 13 May 2016 08:10:31 GMT

chk dis

Load Data from Multiple CSV files