topic Re: tmap convert date + Integer to a string in Talend Studio

tmap convert date + Integer to a string

Anonymous — Thu, 13 Jun 2019 23:20:09 GMT

I am trying to combine both a date and integer type field into 1 string field. This is what I have : (String.valueOf(row1.CONTACT_ID)+TalendDate.formatDate("yyyy-MM-dd",row21.CREATED_DT)) . it's not working, when I run the subjob i'm getting the error: row1 cannot be resolved to a variable.

What am I doing wrong?

Re: tmap convert date + Integer to a string

TRF — Fri, 14 Jun 2019 00:00:14 GMT

If both CONTACT_ID and CREATED_DT fields are issued from the same flow, you should have row21 twice.

Else share this part of your job design including schemas.

Re: tmap convert date + Integer to a string

Anonymous — Fri, 14 Jun 2019 07:31:26 GMT

@aleif kindly find the details below

(String.valueOf(row1.contactid)+TalendDate.formatDate("yyyy-MM-dd",row1.createdDT))

Thanks,

Prabuj

/ Don't forget to give kudos /

Re: tmap convert date + Integer to a string

Anonymous — Fri, 14 Jun 2019 14:34:56 GMT

Hi,

You can also use the tConvertType to convert the data from one data type to another. In your case, you can set the target data type as to String.

https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/GDoeGgb~qKpyQ_84gB37WQ

The existing solutions outlined by other members also will work but I thought to introduce this component for future 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 🙂

Re: tmap convert date + Integer to a string

Anonymous — Tue, 16 Jul 2019 19:30:26 GMT

actually i have this now and i'm still getting a result that the output column needs to be a string.

String.valueOf((row21.CONTACT_ID)+(TalendDate.formatDate("yyyy-MM-dd",row21.CREATED_DT)))

In the tLogRow for reject i'm getting

INVALID_ARGUMENT_TYPE| |XXXX_ID__c must be a string