Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I inherited an application.
I found the Load statements for a QVD file; however, I can't find the STORE statement in the QV code.
Where else could such a STORE statement be hiding?
Here's an example of the LOAD I found ...
COMP_DEDUP_HOST:
LOAD INVENTORY_ID,
TASK_ID,
DATASRC as DATASRC_DEDUP_HOST,
HOST_ID,
UPPER(OPERATINGSYSTEM_LABEL) as OPERATINGSYSTEM_LABEL ,
Autonumber(UPPER(OPERATINGSYSTEM_LABEL & '_' & DATASRC),'KEY_OS_DATASRC') as KEY_OS_DATASRC,
Autonumber(INVENTORY_ID & '_' & TASK_ID & '_' & HOST_ID,'KEY_INV_TASK_HOST') as KEY_INV_TASK_HOST,
RN,
OPERATINGSYSTEM_TYPE_LABEL AS OPERATINGSYSTEM_TYPE_LABEL_DEDUP_HOST //2017-11-28
FROM
[..\QVDs\SEAMDAAS.EDM.COMP_DEDUP_HOST_$(vToday).qvd]
(qvd) where IS_LAYER = 1;
(also - I'm not sure what IS_LAYER is)
Here are two methods to determine what qvw created a QVD.
1. Download and install the Qviewer utility from http://www.easyqlik.com/ . It's a fast download and install.
2. Double click the QVD file to open it in QViewer. Select "Metadata", "File Metadata" from the menu and you will see the "Creator" field which gives the full path to the qvw that created this QVD.
Option 2, if you don't want to use QViewer (don't know why not 🙂
1. Open the QVD in a text editor like Notepad. Near the top you will see a <CreatorDoc> element that contains the path to the creator.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Here are two methods to determine what qvw created a QVD.
1. Download and install the Qviewer utility from http://www.easyqlik.com/ . It's a fast download and install.
2. Double click the QVD file to open it in QViewer. Select "Metadata", "File Metadata" from the menu and you will see the "Creator" field which gives the full path to the qvw that created this QVD.
Option 2, if you don't want to use QViewer (don't know why not 🙂
1. Open the QVD in a text editor like Notepad. Near the top you will see a <CreatorDoc> element that contains the path to the creator.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com