topic Re: Date Column value rejection using TalendDate.isDate in Talend Studio

Date Column value rejection using TalendDate.isDate

abhi90 — Tue, 24 Apr 2018 19:59:05 GMT

Hi All,
I have a scenario where I am converting My Date Column from String to Date. Now if any other format Date comes it will go to error Table.
I am converting String to Date in tmap variable port using below
Var1=talenddate.Formatdate("MM/dd/yyyy",Talenddate.paresedate(datecolumn,"MM/dd/yyyyy"))
Var2(where validating date)=Talenddate.isdate(Var1,"MM/dd/yyyy")
Now in Pass and fail output Table of tmap condition given Var2==true and Var2==false
Now data in datecolumn is converting and going properly to original Table. But for negetive Testing Part if any data is like 2016/22/25 it is not going to Error Table. Can anybody please help
@rhall,@TRF,@vboppudi

Re: Date Column value rejection using TalendDate.isDate

vboppudi — Tue, 24 Apr 2018 20:43:23 GMT

Hi,

are you looking foe the following output?

Regards,

Re: Date Column value rejection using TalendDate.isDate

abhi90 — Wed, 25 Apr 2018 14:54:01 GMT

Hi @vboppudi,

Using this. But all data going to error Table Now.

TalendDate.isDate(row1.MONTH_OF_DATE,"MM/dd/yyyy",true). Data is in MM/dd/yyyy

Re: Date Column value rejection using TalendDate.isDate

vboppudi — Wed, 25 Apr 2018 15:20:16 GMT

Please provide some sample source data.

Regards,

Re: Date Column value rejection using TalendDate.isDate

abhi90 — Wed, 25 Apr 2018 15:36:23 GMT

Hi @vboppudi,

Please find it

3/1/2016
4/1/2016
5/1/2017
2016/22/35

Top 3 should go to Normal and Below One 2016/22/35 should go to error. Input coming to tmap is String and converting that to Date using TalendDate.parseDate("MM/dd/yyyy",row1.MONTH_OF_DATE).

This is the Boolean Variable Port condition for seggregating data

TalendDate.isDate(row1.MONTH_OF_DATE,"MM/dd/yyyy",true)

Re: Date Column value rejection using TalendDate.isDate

vboppudi — Wed, 25 Apr 2018 15:47:59 GMT

Hi,

Please see below

Filter logic: TalendDate.isDate(row2.inDate,"M/d/yyyy",true)

Regards,

Re: Date Column value rejection using TalendDate.isDate

abhi90 — Wed, 25 Apr 2018 16:15:31 GMT

Hi @vboppudi,

I inserted 35/2017/22 this record in my file. It went to reject. But going there It converted to something like this 5/10/0030. I am taking My date Column to tmap Pass and ERROR Table of Output and converting there using TalendDate.parseDate("MM/dd/yyyy",row1.MONTH_OF_DATE). Snapshots attached

tmap_fail.JPG
tmap_pass.JPG

Re: Date Column value rejection using TalendDate.isDate

vboppudi — Wed, 25 Apr 2018 16:21:28 GMT

Are you trying to convert invalid dates to specific format?

If yes, that is not going to work because you don't know the format input value coming.

Please let us know you exact requirement.

Regards,

Re: Date Column value rejection using TalendDate.isDate

abhi90 — Thu, 26 Apr 2018 08:55:01 GMT

Hi @vboppudi,

Yess You were right. I was trying to convert Invalid Date to Right Format which was causing Issue. Changing Datatype to String in Error Table and dragging from Input Date Column to ERROR Table DateColumn Port of tmap resolved my Issue. Marking the Post as resolved.