topic Re: tell me below req? in QlikView

tell me below req?

gkcchowdary — Tue, 11 Aug 2015 10:15:53 GMT

table store into qvd

after extract table into qv table path like below

example:c:/user/chaitanya.qvd

my req:i want load with out path name and qvd name.i want only table name how?

Re: tell me below req?

sunny_talwar — Tue, 11 Aug 2015 10:20:23 GMT

my req:i want load with out path name and qvd name.i want only table name how?

Not sure what you mean. Can you re-explain?

Re: tell me below req?

jonathandienst — Tue, 11 Aug 2015 10:21:04 GMT

You would have to loop over the files, and use the QvdTableName() function to find file(s) containing the table. Something like

Set vTable = Table1;

For Each vFile in FileList('<your qvd path>')

If(QvdTableName(vFile) = vTable Then

LOAD * From [$(vFile)] (qvd);

End If

Next

Re: tell me below req?

jonathandienst — Tue, 11 Aug 2015 10:21:58 GMT

Although as a better tip, why not name the qvd file with the name of the table?

Re: tell me below req?

gkcchowdary — Tue, 11 Aug 2015 14:27:05 GMT

just i want extract existing qvd table .

my requirement is only show the table name without pathname and qvd

On Tue, Aug 11, 2015 at 3:22 AM, jonathan dienst <qcwebmaster@qlikview.com>

Re: tell me below req?

Anonymous — Tue, 11 Aug 2015 14:29:34 GMT

hi,

assign path to variable and use variable name.

Jonathan example solves your issue

Re: tell me below req?

jagan — Tue, 11 Aug 2015 14:50:36 GMT

Hi,

Without filepath how it will load the QVD file? You have to somehow give the file path directly or indirectly like any of the below options

LET vFilePath = 'C:\Qlikview\';

TableName:

LOAD

FROM $(vFilePath)QVDFileName.qvd (qvd);

OR relative path like below

TableName:

LOAD

FROM ..\..\..\QVDFileName.qvd (qvd);

Hope this helps you.

Regards,

Jagan.

Re: tell me below req?

qlikviewwizard — Wed, 12 Aug 2015 06:13:36 GMT

Hi nbkchaitanya

Just put all the files in same folder. Then no need to give any path name.