Apply Map issue

[Anonymous]

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;

[senpradip007 · Accepted solution]

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

[ashfaq_haseeb]

Like this

ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost;

Regards

ASHFAQ

[avinashelite]

Hi,

Remove the Single cotes for ProductID

ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost;

[Anonymous]

Thanks Pradeep.....