Want to read a QVD file from Specified Location. Could you Provide Sample Query

[#1]

Hi Guys,

I want to read (Select Query) QVD file from Specified Location. What would be the Syntex?

This is working fine when I keep DIM_EMP_DATA.QVD on path E:\QlikView

DIM_EMP_DATA:

LOAD

EMP_KEY AS _EMP_KEY,

EMP_ID

FROM DIM_EMP_DATA.QVD (qvd);

But I kept that QVD file to E:\QlikView POC\Data Source QVD Files and Wanted to read from here

Is this correct Syntex?

DIM_EMP_DATA:

LOAD

EMP_KEY AS _EMP_KEY,

EMP_ID

FROM  E:\QlikView POC\Data Source QVD Files\DIM_EMP_DATA.QVD (qvd);

[its_anandrjs]

This is correct path

[its_anandrjs · Accepted solution]

You can write this in below script way also

DIM_EMP_DATA:

LOAD

EMP_KEY AS _EMP_KEY,

EMP_ID

FROM

(qvd);

[kaushiknsolanki]

Hi,

     You can simply click on the relative path option next to "Table Files" in edit script and open your QVD from there.

Regards,

Kaushik Solanki    

[#5]

Hi Shivendoo,

Yes, Its Correct Path. But if u want to hide path u can choose the relative path as suggested by the Kaushik.

Regards

Deepak