topic Re: Reading time in CSV file using Dynamic schema in Talend Studio

Reading time in CSV file using Dynamic schema

Prakhar1 — Sat, 16 Nov 2024 01:06:14 GMT

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?

Re: Reading time in CSV file using Dynamic schema

vikramk — Tue, 17 Nov 2020 12:20:16 GMT

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.

Re: Reading time in CSV file using Dynamic schema

Prakhar1 — Tue, 17 Nov 2020 13:01:51 GMT

Yes i have used the dynamic on both the side.

Yes how can i convert the type in dynamic

Re: Reading time in CSV file using Dynamic schema

Anonymous — Wed, 18 Nov 2020 04:25:28 GMT

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

Re: Reading time in CSV file using Dynamic schema

Anonymous — Wed, 18 Nov 2020 07:54:36 GMT

@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

Re: Reading time in CSV file using Dynamic schema

Prakhar1 — Wed, 18 Nov 2020 10:12:36 GMT

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

Re: Reading time in CSV file using Dynamic schema

Prakhar1 — Wed, 18 Nov 2020 10:13:13 GMT

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

Re: Reading time in CSV file using Dynamic schema

Prakhar1 — Thu, 19 Nov 2020 06:26:32 GMT

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

Re: Reading time in CSV file using Dynamic schema

Anonymous — Thu, 19 Nov 2020 07:35:31 GMT

@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