Reloadind problem

Tue, 31 Mar 2015 12:43:47 GMT

I have script like This ,

When ever Reloading I am getting error.

The error is,

Cannot open file 'D:\Qlikview Development\Ramesh\Product_Hierarchy.qvd' The system cannot find the file specified.

ProductMaster:
LOAD
UPPER(ProductCode) AS ProductCode,
Upper(Modelcode) AS Modelcode
FROM
Product_Hierarchy.qvd
(qvd)

plz give me right solution.

$(Include=F:\production\data source\stages config path.txt); This is configuration fille

sales:
LOAD LinkCommonDate,
// Transactional_ModelCode,
// GT_MT_Channel,
// [Transactional Product Code],
// Product_Code_SKU,
// Invoice_No,
// Order_No,
[Sales Gross Qty],
[Sales Return Qty],
[Sales Net Qty],
BuyerCode_Old,
SellerCode,
// Seller_HQFlag,
// Buyer_HQFlag,
// CommonDistCode,
// MDCode,
// RDSCode,
// ZDCode,
// NDBRCode,
[Type Of Sales],
// DealerPrice,
// [Sales Gross Amt],
// [Sales Return Amt],
// [Sales Net Amt],
// [Sales USD Gross Amt],
// [Sales USD Return Amt],
// [Sales USD Net Amt],
// Pri_Invoice_Amt,
// Pri_Invoice_Discount,
// Pri_Invoice_TaxableAmt,
// Pri_Invoice_TaxAmt,
// Pri_Invoice_TotalAmt,
// TP_Invoice_USD_Amt,
// TP_Invoice_Amt,
// [Sales USD TP Gross Amt],
// [Sales TP Gross Amt],
// [Sales USD TP Return Amt],
// [Sales USD TP Net Amt],
// [Sales TP Return Amt],
// [Sales TP Net Amt],
// OrderReason,
// Distributor_Mapping,
// Transaction_Type_All,
// Transaction_Type,
// Transaction_Type_MDSZD,
// Buyer_Status_key,
// Seller_Status_key,
// SalesTransaction,
// [Sales Type],
// Seller_ApproveStatus,
// Buyer_ApproveStatus,
// City,
// Country,
// [Product Segment],
[Product Group],
// Operator,
// Activation_Circle,
// Transaction_Type_SellOut,
//VALIDATION,
// VALIDATION_Remarks,
[Month Week Start],
[Month Week End],
ProductCode,
BuyerCode
// DealerCode,
// PSI_Flagging,
// Region,
// REGION,
// State,
//STATE,
// SalesTargetKey
FROM

(qvd);

//Masters

ProductMaster:
LOAD
UPPER(ProductCode) AS ProductCode,
Upper(Modelcode) AS Modelcode
FROM
$(STAGE2_MASTER_QVD_PATH)Product_Hierarchy.qvd
(qvd);

LOAD
Upper(ModelCode) as Modelcode,
MarketName
FROM
$(STAGE1_MASTER_QVD_PATH)JOAPRODUCTCATEGORY.qvd
(qvd);

ProductMapping:

LOAD ProductCode,
MarketName
RESIDENT ProductMaster;

ModelCodeMapping:

LOAD ProductCode,
Modelcode
RESIDENT ProductMaster;

DROP TABLE ProductMaster;

ProductDesc:

LOAD Upper(ProductCode) AS ProductCode,
ProductDesc

FROM
$(STAGE1_MASTER_QVD_PATH)PRODUCTMASTER.qvd
(qvd);

//Config File

//$(Include=F:\production\data source\stages config path.txt);

Re: Reloadind problem

PrashantSangle — Tue, 31 Mar 2015 12:46:42 GMT

Hi,

As your error suggest Cannot open file 'D:\Qlikview Development\Ramesh\Product_Hierarchy.qvd' The system cannot find the file specified.

Just confirm that you have qvd at that file location.

Regards

Re: Reloadind problem

Tue, 31 Mar 2015 12:51:54 GMT

hi @babu

Just check your file path

The file path of your Qv should be correct other wise it shows errors in script of the file

Re: Reloadind problem

MK_QSL — Tue, 31 Mar 2015 12:55:34 GMT

Check your variable declaration...

STAGE2_MASTER_QVD_PATH

Re: Reloadind problem

prabhas277 — Tue, 31 Mar 2015 12:55:59 GMT

Hi Babu,

The qvd file in that location is not found so check it once properly.

Re: Reloadind problem

Tue, 31 Mar 2015 13:20:27 GMT

Hi,

You can Set variable path below one.

STAGE2_MASTER_QVD_PATH = D:\Qlikview Development\Ramesh\

topic Re: Reloadind problem in QlikView

Reloadind problem

Re: Reloadind problem

Re: Reloadind problem

Re: Reloadind problem

Re: Reloadind problem

Re: Reloadind problem