[Robust Transformation] 'Convert to Date' operation type not populating the date value to target table.

[Kishore32]

Hi,

I've created 'Date' RTE Entity Operation on staging table in Robust Transformation. Its not converting the string date value from importset to target. In target I'm seeing empty value.

Please help me here. Why date value to not populating in the target table.

Thanks,

[sonali panda1]

How is the data in the excel and what is the format the target table is accepting? Did you check the staging table has the data stored correctly?

[Kishore32]

Thanks for responding so quickly. 

Staging table in RTE don't have any table.

Excel date as follows

But in import set I saw data coming as follows

Target table field column

[sonali panda1]

Hi,

In the import set table for that field, instead of string type can you change it to date format as you would want your target field to accept. Then import and see in import history what error message is showing. For previous imports also let me knw what is the error for the records in transform history.

[Kishore32]

There is no date data type for the importset table

I didn't see any errors. Please look into below screen shots.