tell me below req?

[gkcchowdary]

hi

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?

[sunny_talwar]

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?

[jonathandienst]

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

[jonathandienst]

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

[gkcchowdary]

hi

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>

[Anonymous]

hi,

assign path to variable and use variable name.

Jonathan example solves your issue

[jagan]

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.

[qlikviewwizard]

Hi nbkchaitanya

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