topic Re: extract year from date type variable in Talend Studio

extract year from date type variable

Anonymous — Sat, 16 Nov 2024 13:55:42 GMT

Hello,
I m using TOS3.10 / java under windows xp and I wonder how I can extract the year part of a date or datatime type?
I will use it in an expression filter of a Tmap. From several tables i want to make a join but not all rows of the input table are suitable for the join.
Can someone help me, since i do not know anything of java.
Michel

Re: extract year from date type variable

Anonymous — Mon, 08 Jun 2009 18:50:54 GMT

You can get the year using the Talend Date routines :

TalendDate.formatDate("yyyy",rowX.myDate)

Re: extract year from date type variable

Anonymous — Mon, 08 Jun 2009 19:51:13 GMT

Thanks bcourtine for your respond,
I put your suggestion in the expression filter of the tMap but it returned with an error message which says:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
The left-hand side of an assignment must be a variable
See below a screenshot of my tMap design.
Can you please give your reaction. Can you perhaps explain to me what went wrong?
Thanks in advance,
Michel

Re: extract year from date type variable

Anonymous — Tue, 09 Jun 2009 02:42:44 GMT

Hello
There should be double '=',eg:
TalendDate.formatDate("yyyy",row1.date)=="2009"
Best regards

shong

Re: extract year from date type variable

Anonymous — Tue, 09 Jun 2009 19:36:31 GMT

Hello Shong,
thanks for the reply, it works(which means no error message) but I 've no output. And I'm sure the yearpart 2009 or 2999 is in the table.
The date 2999-01-01 can be the value of the variable scd_end which is in the script:
TalendDate.formatDate("yyyy",row1.Scd_end)=="2009"
I doubt if the value of the TalendDate.formatDate("yyyy",row1.Scd_end) is a character value. It is for sure that the value is not the same as 2009 or 2999.
I hoped the following took place: "2009" = "2009" (so that particular row was selected).
Can you explain a solution.
Regards,
Michel

Re: extract year from date type variable

Anonymous — Wed, 10 Jun 2009 04:40:28 GMT

Hello
The method TalendDate.formatDate return a string, so you can try the following expresson:
TalendDate.formatDate("yyyy",row1.Scd_end).equals("2009")
Best regards
shong

Re: extract year from date type variable

Anonymous — Wed, 10 Jun 2009 08:46:27 GMT

Shong,
thank you very much for your help, it works now! One more question, I've submit several question related to TOD, but no answer. Do you know why? Can you inform a colleque of you for me please? I would very much appreciate that.
Thanks in advance,
Michel

Re: extract year from date type variable

Anonymous — Tue, 03 Feb 2015 09:09:01 GMT

Hi all,
I have the same problem like micoppoolse, but in my case i want to get year of the current date.
I do so something like this, but it don't work.

TalendDate.formatDate("yyyy",TalendDate.getCurrentDate())

So may somebody help me please?
Thank you.

Re: extract year from date type variable

Anonymous — Tue, 03 Feb 2015 09:49:44 GMT

Here is for you IDEMBELE :
TalendDate.getDate("CCYY")

Re: extract year from date type variable

Anonymous — Tue, 03 Feb 2015 10:56:26 GMT

Hi mathis,
Thank you, but this code

TalendDate.getDate("CCYY")

return a boolean
So to resolve the problem, i use this code

TalendDate.formatDate("yyyy",new Date())

Re: extract year from date type variable

Anonymous — Mon, 27 Jun 2016 13:55:39 GMT

Hi,
My requirement is:
I have a huge csv file and i would like to generate multiple files for each year(Only based on year) and these files has to save into their respective year folders automatically. I have a date column.
it is very urgent. Plz help me on this.
kind regards,
Asha

Re: extract year from date type variable

Anonymous — Mon, 27 Jun 2016 14:13:37 GMT

org.talend.designer.hdfsbrowse.exceptions.HadoopServerException: org.talend.designer.hdfsbrowse.exceptions.HadoopServerException: java.util.concurrent.ExecutionException: java.lang.reflect.InvocationTargetException
            at org.talend.designer.hdfsbrowse.hadoop.service.check.AbstractCheckedServiceProvider.checkService(AbstractCheckedServiceProvider.java:51)
            at org.talend.designer.hdfsbrowse.hadoop.service.HadoopServiceBean.check(HadoopServiceBean.java:102)
            at org.talend.designer.hdfsbrowse.hadoop.service.check.CheckHadoopServicesDialog$5.run(CheckHadoopServicesDialog.java:373)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
     &n

To see the whole post, download it here
OriginalPost.pdf

Re: extract year from date type variable

Franz3 — Mon, 27 Jun 2016 15:01:27 GMT

Lol i can't say for the error just ahead but for the date you have several options.
The easiest way is to open n times your file, not very efficient bur pretty simple
1)you get all the years, uniq those years, then you iterate (tflowtoiterate)
At this point you have an iteration for each different year in your csv
2) you put the year in a variable, then you reopen your file and filter on the year you need, and when you write on your files, you just have to put your variable in the file path.
could be something like

tFileInputDelimited
tUniqRow
tFlowToIterate
tFileInputDelimited
tFilterRow
tFileOutputDelimited

Re: extract year from date type variable

Anonymous — Tue, 09 Aug 2016 12:02:14 GMT

Hi guys,
Need your help on getting the year only of a date field, i tried using this TalendDate.formatDate("yyyy",rowX.myDate)
but I am having an error below " The cell format is not Date in ( Row. 1 and ColumnNum. 2 ) "

can you help me ?