Mapping Query

[Former Member]

Hi All,

I have a mapping requirement as

Source field is sourcedate while the target field is targetdate.

If the sourcedate value is there then only it should be mapped to the targetdate else it should not be mapped.

I tried to implement it with IF THEN ELSE but, could not understand what should be put in to the ELSE part if the sourcedate field is not having any value?

Can you please help me?

Thanks in advance

[Former Member]

answered

[Former Member]

Use ifWithoutElse, Constant, equalS, & Not functions and apply this logic if sourcedate not equals empty then map sourcedate.

[Former Member]

Hi Shwetha

Use If without else

Babu

[Former Member]

Hi Babu,

Thanks for the reply.

I used the If without else,but still the error is coming as

Runtime exception when processing target-field mapping /Message/../.../TargetDate; root message: Unparseable date: ""

The mapping requirement is that if the SourceDate field is present then it should be mapped to the TargetDate fieldelse the TargetDate field should be empty.

The mapping with the date transformation is SourceDate->DateTransformation->TargetDate

In the DateTransformation,the Input date format is yyyymmddhhmmss while the output date format is yyyymmdd.

Can you plese help me?

Thanks in advance

Edited by: Shweta Kullkarni on Sep 27, 2010 3:18 PM

[Former Member]

Hi Swetha,

You can Use Map with Default function to satisfy your requirement.

Thanks,

[Former Member]

Hi Hareenkumar,

I tried with mapwithdefault also but it is not working.

Can you please help me?

Thanks in advance