Home


About Talend

Talend’s data integration products provide an extensible, highly-performant, open source set of tools to access, transform and integrate data from any business system in real time or batch to meet both operational and analytical data integration needs. With 450+ connectors, it integrates almost any data source. The broad range of use cases addressed include: massive scale integration (big data/ NoSQL), ETL for business intelligence and data warehousing, data synchronization, data migration, data sharing, and data services.



My Latest Video on Talend tMap settings


3 comments:

  1. Hi all,

    we have "firstorder_date" filed. it have data like below:

    firstorder_date
    -------------------
    2013-01-05 00:01:02
    2013-05-15 03:00:05
    2013-06-20 10:20:15

    2013-05-12 05:06:25

    2013-10-20 06:22:22

    i want to split firstorder_date filed and insert into
    date into "firstorder_date" field and
    Time into "firstorder_time" field. and

    firstorder_date have some null values.
    i want process null values same as it is.


    output:
    ---------

    firstorder_date firstorder_time
    ------------------ ---------------------
    2013-01-05 00:01:02
    2013-05-15 03-00-05
    2013-06-20 10:20:15

    2013-05-12 05:06:25

    2013-10-20 06:22:22





    Please give me your advice's to achieve desire output.


    Thanks
    kumar.talend

    ReplyDelete
  2. Hi Kranti,


    FIRSTORDER_DATE Formula

    StringHandling.LEN(row1.Column0)>0?
    TalendDate.formatDate("yyyy-MM-dd",
    TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row1.Column0)):""


    FIRSTORDER_TIME Formula

    StringHandling.LEN(row1.Column0)>0?
    TalendDate.formatDate("HH:mm:ss",
    TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row1.Column0)):""

    Thanks
    Manas

    ReplyDelete