Transformation Logic

[Former Member]

Hi Experts,

I am trying to load data from a CSV file.

I have a date field through which i am trying to populate value for a field called Status. Logic is, If the Date field is empty then status =2 else status =1.

Simple logic but don't know where am going wrong!!!

I have used routine and formula but both didn't work. Status "1" is successfully loading to the fields in which Date is not Empty but Status is not Loading at all, All the time it is showing empty only...

I have tried with ' ' , '00.00.0000' and '00000000' ... but none of them are working...

This is the result what am getting every time...

Activation Date	Activated By	Activation Status
11-11-2010	DATA  ENTRY	1
11-11-2010	DATA  ENTRY	1
12-11-2010	DATA  ENTRY	1
16-11-2010	DATA  ENTRY	1
16-11-2010	DATA  ENTRY	1
22-11-2010	DATA  ENTRY	1
#	#	Not assigned
#	#	Not assigned
#	#	Not assigned
#	#	Not assigned

Please suggest some inputs, Highly appreciate your help.

Thanks & Regards,

Anil.

[KulDeepJain · Accepted solution]

Hi Anil,

Your requirement is simple enough. Use below code for that;

IF source_fields-/BIC/IOcalday is not initial.

  RESULT = '1'.

  ELSE.

     RESULT = '2 '.

ENDIF.

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Check if this helps:

IF SOURCE_FIELDS-calday is initial.

  RESULT = '2'.

  ELSE.

     RESULT = '1 '.

ENDIF.

[Former Member · Accepted solution]

Already I have tried it Sir, But It is not working...

Data is loading only for the records which has date..

Thanks for your reply.