@saikiran_nemani wrote:
CASE
WHEN LEFT(je.product_id__c, 1) = 'C' THEN
RIGHT(je.product_id__c, Len(je.product_id__c) - 1)
ELSE je.product_id__c
END AS Product_ID
Please I want the code and what are the Functions used for Left,Right and Len in HADOOP
This is a complete guess on my part as HADOOP can involve more than one DBMS.
I would start by trying standard SAS functions
Instead of LEFT try SUBSTR(je.product_id__c,1,1) to get the first character, LENGTH instead of LEN and SUBSTR(je.product_id__c, Length(je.product_id__c) - 1).
The SAS functions Left and Right justify variable values. If a variable contains " text" (2 leading spaces) then Left(var) = "text" so that the non-blank text starts in the first position. The Right function moves trailing blanks to the start: Right ("text ") = " text".
So I suspect your code may have given you errors related to too many parameters for the Left and Right functions.
