Reloadind problem

[#1]

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);

[PrashantSangle]

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

[#3]

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

[MK_QSL]

Check your variable declaration...

STAGE2_MASTER_QVD_PATH

[prabhas277]

Hi Babu,

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

[#6]

Hi,

You can Set variable path below one.

STAGE2_MASTER_QVD_PATH = D:\Qlikview Development\Ramesh\