Skip to Content
0
Jul 02, 2013 at 04:59 AM

Clarification needed in comparing fields

20 Views

Hi Experts,

The scenario goes like this:

Two fields are there Field A and Field B.

Field A has the value of type currency

Field B has the value of type date

Now from the source file I have to check if the value is coming for the field A i.e. currency if so then,

1) Check in data manager if the Field A has the same value for currency as that of the file , if so do not update the value from the source file into Data manager and also the date from the file.

2) Check in data manager if the Field A is null, if so then update the source field value and also the date from the source file for Field B.

3) Check in data manager if the Field A value is different from that of source file , if so then update the new value and also the date of Field B.

I have created now a new field in data manager and assigned that field with the value from existing field A using assignment before the source file updates in order to compare using an assignment.

Can anyone let me know how to assign the existing value of a field of type currency to that new field.

If it is look up flat we use FieldA.Record , so how it is for field of type currency.

Thanks in advance.

Regards,

Neethu