topic Re: incremental load tMap help in Talend Studio

incremental load tMap help

Anonymous — Thu, 21 Dec 2017 02:02:05 GMT

Hi, I am trying to do the incremental load of XML files. I do have date column on yyyy-MM-dd HH:mm:ss which is row2.updatedtimestamp. On first row I am trying to convert my string type data to date format. On the second row I am trying to get the current time.

On the third row I am doing the date differennce with the my date column (row2.updatedtimestamp) with flag.

But the problem is that I am keep getting error as;

Type mismatch: cannot convert from Date to String.

Could you please let me know what is wrong? I also have shared the screenshot of job

Expression	Type	Variable
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row2.updatedtimestamp )	Date	format_date
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",TalendDate.getDate("yyyy-MM-dd HH:mm:ss"))	Date	Current_date
TalendDate.diffDate(Var.Current_date,Var.format_date,"dd") == 126 ?true:false	Boolean	Out_Flag

Re: incremental load tMap help

Anonymous — Thu, 21 Dec 2017 13:07:56 GMT

Hi,

What's the complete code executed for the "diff_date" var ??

PS : You can activate the Code Mode to see exactly where is the problem !

Re: incremental load tMap help

Anonymous — Thu, 21 Dec 2017 19:31:52 GMT

Sorry forgot to mention that. That error is at Var.format_date as the code.

And the complete code to date_diff is as;

Proff_tmp.diff_date = TalendDate

.diffDate(Var.Current_date,

Var.format_date, "dd");

Re: incremental load tMap help

Anonymous — Fri, 22 Dec 2017 08:28:07 GMT

Ok i get it !

Change type of your updatetimestamp column to date type !

Good luck

SGV

Re: incremental load tMap help

Anonymous — Fri, 22 Dec 2017 12:11:08 GMT

I tried that. It gives following error.

The method parseDate(String, String) in the type TalendDate is not applicable for the arguments (String, Date)

Re: incremental load tMap help

Anonymous — Mon, 25 Dec 2017 07:08:31 GMT

Hello,

The method TalendDate.parseDate() needs String date not Date date. You can use TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("dd/MM/yyyy")) to achieve your goal.

Best regards

Sabrina

Re: incremental load tMap help

Anonymous — Mon, 25 Dec 2017 16:47:20 GMT

Thanks for the input but that gets me bellow error;

The method formatDate(String, Date) in the type TalendDate is not applicable for the arguments (String)

Re: incremental load tMap help

Anonymous — Tue, 26 Dec 2017 06:46:02 GMT

Hi,

@brawal wrote:

Thanks for the input but that gets me bellow error;

The method formatDate(String, Date) in the type TalendDate is not applicable for the arguments (String)

Would you mind posting your current expression setting screenshot in tMap into forum?

Best regards

Sabrina

Re: incremental load tMap help

Anonymous — Tue, 26 Dec 2017 19:10:05 GMT

I have mentioned on the original post. The expression is as;

Expression	Type	Variable
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row2.updatedtimestamp )	Date	format_date
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",TalendDate.getDate("yyyy-MM-dd HH:mm:ss"))	Date	Current_date
TalendDate.diffDate(Var.Current_date,Var.format_date,"dd") == 126 ?true:false	Boolean	Out_Flag

And screenshot;

Re: incremental load tMap help

Anonymous — Fri, 05 Jan 2018 05:19:59 GMT

Please let me know if you are not clear.

Re: incremental load tMap help

Anonymous — Fri, 05 Jan 2018 11:45:29 GMT

Do This:

- If row2.updatedtimestamp is of type Date then use below expression for format_date
TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row2.updatedtimestamp) )

- If row2.updatedtimestamp is of type String with value like "23-05-2017" and you want a format like "2017-05-23 12:34:00" then use below expression for format_date
TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",TalendDate.parseDate("dd-MM-yyyy",row2.updatedtimestamp))

- Change the data type of variable format_date to String