I have a problem with date format, because data has differents kinds of format in columns where data is date, formats are:
Wed Mar 23 14:56 2019
And any format that you can imagine.
So, I need to the format will be English format "20-02-2019" in one, in other I need format "12-07-2019 14:35", I have the next definition:
If my understanding about your query is correct, you are expecting the incoming date to be in any format and you would like to convert them to a standardized output format.
If you are using Talend Studio, it expects the incoming date in a specific format else you will have to write a marathon list of all possible combinations to convert the date to a standardized format.
But there is an easy solution if you are using subscription version of Talend where you can use Talend Data Preparation to do the cleansing activity. You can create a rule in the Talend Data Preparation recipe where you want to standardize the incoming date. This recipe will be called from Studio to perform the cleansing and you will get standard date in the output.
Please refer the below link for the details.
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 :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Test drive Talend's enterprise products.