Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Am applying the below code but i got empty fields in date field i want date so can u plzzz suggest me
find attachment
Calender:
LOAD CAD_Activity_ID,
CAS_Date_Value,
CAM_ID,
CAS_Remarks,
CAS_Status,
CAS_Updated_By,
if (CAS_Updated_Date = (CAS_Value_Type='A'), 'CAS_Updated_Date')as Date1,
if (CAS_Updated_Date = (CAS_Value_Type='T'), 'CAS_Updated_Date')as Date2,
if (CAS_Value_Type='A', 'A')as CAS_Value_Type1,
if (CAS_Value_Type='T', 'T')as CAS_Value_Type2 ,
CAS_Version
FROM
(qvd);
I think your formula is not right:
if (CAS_Updated_Date = (CAS_Value_Type='A'), 'CAS_Updated_Date')as Date1,
means:
if date field = true then give then return the date field.
Since the data field does not contain a true or false value it will never return the date.
You probably want to use the following expression:
if (CAS_Value_Type='A', CAS_Updated_Date)as date1
regards,
Bert
You are comparing:
CAS_Updated_Date to a boolean value (0 or 1) resulting from the expression: CAS_Value_Type='A'
so if CAS_Updated_Date has a date format it will never be equal to 0 or 1
Hope it helps
I think your formula is not right:
if (CAS_Updated_Date = (CAS_Value_Type='A'), 'CAS_Updated_Date')as Date1,
means:
if date field = true then give then return the date field.
Since the data field does not contain a true or false value it will never return the date.
You probably want to use the following expression:
if (CAS_Value_Type='A', CAS_Updated_Date)as date1
regards,
Bert
LOAD CAD_Activity_ID,
CAS_Date_Value,
CAM_ID,
CAS_Remarks,
CAS_Status,
CAS_Updated_By,
if (CAS_Value_Type='A', CAS_Updated_Date)as Date1,
if CAS_Value_Type='T', CAS_Updated_Date)as Date2,
if (CAS_Value_Type='A', 'A')as CAS_Value_Type1,
if (CAS_Value_Type='T', 'T')as CAS_Value_Type2 ,
CAS_Version
FROM
(qvd);