Multiple Excel

NavinReddy — Mon, 18 May 2015 08:35:42 GMT

Dear Experts,

i have multiple excel sheets which i don't know,

when im loading into qlikview how can i know how many excel sheets im loading

Can some one tell me any way to know

Thanks in Advance

Niranjan

Re: Multiple Excel

senpradip007 — Mon, 18 May 2015 08:42:03 GMT

Make an ODBC connection like

ODBC CONNECT32 TO [NSEBSEConn;DBQ=C:\STOCK PRICES.xls];

tables:

SQLtables;

DISCONNECT;

FOR i = 0 to NoOfRows('tables')-1

LET sheetName1 = purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39));

Let sheetName = PurgeChar(trim(sheetName1),'#');

Tab:

LOAD Date,

Date as [BSENSE Date],

[Open Price],

[High Price],

[Low Price],

[Close Price],

Trim(Purgechar(Right('$(sheetName)',Len('$(sheetName)')-4),'$')) as [BSENSE Sheet],

Left('$(sheetName)',3) as [BSENSE Flag]

FROM

(biff, embedded labels, table is [$(sheetName)]);

Hope it will help.