topic Re: loading tables in qlikview in QlikView

loading tables in qlikview

Wed, 16 Mar 2016 06:27:19 GMT

Hi All,

how to load the different tables at a time in qlikview

Regard's

Sai Madhu

Re: loading tables in qlikview

Chanty4u — Wed, 16 Mar 2016 06:29:04 GMT

can u explain more ?

what type of tables u hve ?

can u share ur data?

Re: loading tables in qlikview

Chanty4u — Wed, 16 Mar 2016 06:29:39 GMT

fyI

Types of Load into QlikView

Re: loading tables in qlikview

Wed, 16 Mar 2016 06:31:06 GMT

i have an a different qvd files has different tables, i want to load these file at a time in qlikview

Re: loading tables in qlikview

vikasmahajan — Wed, 16 Mar 2016 06:32:33 GMT

Refer this document from FEBRIC excellent.

Vikas

Re: loading tables in qlikview

Anonymous — Wed, 16 Mar 2016 06:33:53 GMT

Are you facing any issue doing like this?

load

From QVD1;

Load

from QVD2;

Load

from QVD3;

and so on?

Re: loading tables in qlikview

Chanty4u — Wed, 16 Mar 2016 06:34:49 GMT

jst do this

Do you want to load multiple QVD’s from a folder?

Here is the code:

Set vFolder = '.';

FOR each File in filelist (vFolder& '\*.qvd')

LOAD * FROM [$(File)] (qvd);

NEXT File

Re: loading tables in qlikview

Wed, 16 Mar 2016 06:36:46 GMT

can u give any example

Re: loading tables in qlikview

Wed, 16 Mar 2016 06:37:30 GMT

No I am not getting any Issue

Re: loading tables in qlikview

Chanty4u — Wed, 16 Mar 2016 06:37:58 GMT

jsut go through this

Re: loading multiples qvd's from root folder

Re: loading tables in qlikview

Wed, 16 Mar 2016 07:00:53 GMT

I was give like that but it is not working

Data:

LOAD

From E:\(DATA)\Qlikview Files\MRPQV\Extracted*.qvd;

store Data into E:\(DATA)\Qlikview Files\MRPQV\Extracted\sample.qvd;

DROP Table Data;