Reading time in CSV file using Dynamic schema

[Prakhar1]

Hi,

I have csv file having data like :

"StatusID","StatusName","CreatedDateTime","UpdatedDateTime"

"0","Active","6/26/2019 10:12:45 AM","6/26/2019 10:12:45 AM"

Now i want to read columns using "Dynamic" type but it is taking the

"CreatedDateTime" and "UpdatedDateTime" columns as "String" which i want to be in "Timestamp", because the target table columns are in "Timestamp" datatype.

Any idea what can i do here or i need to change target column type?

[vikramk]

Hi @prakhar dubey​ ,

When you use Dynamic schema at source component you should be using dynamic at target as well. Or else define the schema manually at source and target.

Still If you have specific requirement to do so, then you can convert the type. But that is not best practice with Dynamic schema.

Please let me know if it helps.

[Prakhar1]

Yes i have used the dynamic on both the side.

Yes how can i convert the type in dynamic

[Anonymous]

Hello,

Is it possible for you to use the tMap component to map the Dynamic type column to a Date? In this way, you will not use Dynamic type at your target.

Best regards

Sabrina

[Anonymous · Accepted solution]

@prakhar dubey​ , can you take a look at this blog written by Richard, it shows how to get the column metadata properties and change them on tJavaFlex.

Regards

Shong

[Prakhar1]

Sorry @Xiaodi Shi​ but i am not getting what you want to explain..

[Prakhar1]

@Shicong Hong​ sure i will try to check it on my side and will respond if it works for me.

[Prakhar1]

thanks @Shicong Hong​ made some couple of changes in the code and it worked for me

[Anonymous]

@prakhar dubey​ , Wow, it's great! Would you mind sharing some example code of tJavaFlex what you have changed? It will be helpful for the community users who might have the same issues.

Regards

Shong