Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
I have csv file in following format
vm_name,memory,CPU,VM_Created_Date
"prod111","32","2",
"stg","34","4", "7/12/2019 3:23:41 AM"
You can see in row 1 vm_created_date is blank (NOT "", NOT null). It is just blank.
Now in talend DI tmap it convertes the blank date to 1900-01-01 00:00:00.000. And for row 2 where there is date, Talend tmap keeps it as it. (Which is correct)
I want to
1. keep blank as null (in row1)
2. and datetime as datetime (in row2)
How can i do this.
i tried below in tmap but it makes null for everything
TalendDate.isDate(row1.VM_Created_Date,"m/d/yyyy h:mm:ss a")?row1.VMCreateDate:null
Hi,
I believe you are trying like below.
You need to add the component details as below and the schema will have to be configured as below.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Hi,
I believe you are trying like below.
You need to add the component details as below and the schema will have to be configured as below.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
This is how i solved it
Hi,
Thanks for sharing the solution path you had taken. I would personally prefer to avoid the custom coding if we have some graphical option available in Talend tool. Both both options do the same job and will give same results.
Could you please mark both methods as solutions to the post? It will help other Talend community members during their reference.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved