Extract year from a date

[Anonymous]

Hi all, 

I want extract a year from a date by using this function :

Integer.parseInt(TalendDate.formatDate("yyyy",consultation.Date)) 

I find a java error.

Please i request your help to resolve this.

Thank you.

[TRF]

Once again you need to protect yourself again null value for consultation.Date

[Anonymous]

Thank you for your generosity.

Please, now i need another help.

I have  2 tables "consultation" et "beneficiaire" and i want count the number of consultations per beneficiary.

Unfortunately, I do not know how to express this in talend.

Thank you for all.

NombreTotal.png

[Anonymous]

Please what do you think about this :

(consultation.idBeneficiaire == beneficiaire.idBeneficiaire ) ?
NombreTotal = NombreTotal+1

thank you.

[TRF]

The rule is to have 1 question per topic.
Please, accept the preceding then open a new one.

[TRF]

The rule is to have 1 question per topic.
Please, accept the preceding then open a new one.