topic Re: ALL FILE ATTACHED in QlikView

ALL FILE ATTACHED

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

I have number of files with same content but in different name. normally i import files to one by one. as given below

LOAD BCOD,

Category,

Description,

FR,

HH,

TC,

MS,

SS,

SI,

MR,

TT,

PP,

EN,

MW,

MC,

M3,

FROM

\\10.10.1.252\central_accounts_budget\Product_P&L_Dec16\01EXP.xls

(biff, embedded labels, table is HO$);

LOAD BCOD,

Category,

Description,

FR,

HH,

TC,

MS,

SS,

SI,

MR,

TT,

PP,

EN,

MW,

MC,

M3,

FROM

\\10.10.1.252\central_accounts_budget\Product_P&L_Dec16\02EXP.xls

(biff, embedded labels, table is HO$);

is there any possibility to import all the all files i want to script at ones without copy & paste one by one.

sagara

Re: ALL FILE ATTACHED

devarasu07 — Thu, 26 Jan 2017 04:43:20 GMT

Hi,

Check this,

Dynamically Loading Multiple Excel Files

Tks, Dev

Re: ALL FILE ATTACHED

hector_munoz — Thu, 26 Jan 2017 04:45:56 GMT

Hi SANKA PERERA,

There are two possible ways:

Using a mask in the FROM statemet:

LOAD Fecha,

Horas,

Cliente,

[Tipo Tarea],

[Cod. Incidencia],

[Pertenece a QV],

Detalles

FROM [.\HORAS\Horas_Semanales_????????_HMM.xlsx] (ooxml, embedded labels, table is Hoja1);

Using a FOR EACH loop as the following way:

FOR EACH vsFile IN FileList('.\HORAS\Horas_Semanales_????????_HMM.xlsx')

LOAD Fecha,

Horas,

Cliente,

[Tipo Tarea],

[Cod. Incidencia],

[Pertenece a QV],

Detalles

FROM $(vsFile) (ooxml, embedded labels, table is Hoja1);

I hope it helps you.

Regards,
H

Re: ALL FILE ATTACHED

beck_bakytbek — Thu, 26 Jan 2017 08:01:24 GMT

Hi Sanka,

look at this:

Qlikview Load Data from Multiple Excel Sheets by RFB 190 - YouTube

beck

Re: ALL FILE ATTACHED

vinieme12 — Thu, 26 Jan 2017 08:45:39 GMT

try below,This is all you need

LOAD BCOD,

Category,

Description,

FR,

HH,

TC,

MS,

SS,

SI,

MR,

TT,

PP,

EN,

MW,

MC,

M3,

FROM

\\10.10.1.252\central_accounts_budget\Product_P&L_Dec16\*.xls

(biff, embedded labels, table is HO$);