Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I am not getting the apply map field in my app... Below is my code... thanks in advance...
StandardCost_Map:
MAPPING LOAD
ProductID,
StandardCost;
SQL SELECT * FROM Product;
SalesOrderDetail:
LOAD
CarrierTrackingNumber,
DueDate,
OrderQty,
ProductID,
SalesOrderDetailID,
OrderQty*UnitPrice - UnitPriceDiscount AS Sales,
ApplyMap('StandardCost_Map','ProductID','0') AS ProductStandardCost;
venkat vemula wrote:
Hi folks,
I am not getting the apply map field in my app... Below is my code... thanks in advance...
StandardCost_Map:
MAPPING LOAD
ProductID,
StandardCost;
SQL SELECT * FROM Product;
SalesOrderDetail:
LOAD
CarrierTrackingNumber,
DueDate,
OrderQty,
ProductID,
SalesOrderDetailID,
OrderQty*UnitPrice - UnitPriceDiscount AS Sales,
ApplyMap('StandardCost_Map','ProductID','0') AS ProductStandardCost;
Try like:
Load
.....
ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost
From <>;
venkat vemula wrote:
Hi folks,
I am not getting the apply map field in my app... Below is my code... thanks in advance...
StandardCost_Map:
MAPPING LOAD
ProductID,
StandardCost;
SQL SELECT * FROM Product;
SalesOrderDetail:
LOAD
CarrierTrackingNumber,
DueDate,
OrderQty,
ProductID,
SalesOrderDetailID,
OrderQty*UnitPrice - UnitPriceDiscount AS Sales,
ApplyMap('StandardCost_Map','ProductID','0') AS ProductStandardCost;
Try like:
Load
.....
ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost
From <>;
Like this
ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost;
Regards
ASHFAQ
Hi,
Remove the Single cotes for ProductID
ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost;
Thanks Pradeep.....