how to convert String to date in talend

[Anonymous]

hi,
i have date which is in string "MM/dd/yyyy" and i want to convert same format in DATE data type in talend,
means
"MM/dd/yyyy" data type(String) ---> MM/dd/yyyy data type(DATE)
how could i do this please provide the solution.
thanks and regards
Shailendra Shukla

[Anonymous]

Hi,
Could you send the snapshot of you tMSSQLInput??
I am using the target table as input in here. The name of my target table is 'Target'. I am calculating the MAX of all dates present in the Target table through SQL itself. I will get the max date as the output of the tMSSQLInput, and use that in tjavarow. The MaxDate in my code is an alias. The 'Date' in my code (SELECT MAX(date)) is the name of the column containing dates.
Could you check the following in your code:
1. Are you getting the MAX date through Sql input? Maybe you could use a tlogrow to check what you are getting
2. What is the name of your date column? (My date column was 'Date', which i used in the Sql input query)
3. Are you using tjavarow for the variable assignment ? (not tjava, "MaxDate cannot be resolved or is not field error" often comes while using tjava )

[janhess]

Hi any one can help to solve this problem..................
Here i creating a mapping for incremental load logic.
Here i created one context variable with some initial value is called Contex.Last_Date= 01/01/2000
MY Problem is...................
1. For First time load i used insert option in tmssqloutput for full load , here i got full rows from source correctly .
2.But in second load again it reads all the rows from source and its not filter the rows greater than contex.Last_Date, because the value of context variable is not changed in tfilter .

Please any one knows the solution, than kindly help me to solve this.

That's because your context value will be reset to it's original value when you rerun the job.

[Anonymous]

My error is the MaxDate field is cannot be resolved or is not a field.................on tjavarow components.
In your screenshot , u didnot mention table structure and table in Basic setting option on target(tmssqlinput).
Did you get correct output for your process?
Here i attached my screen shot , just check and suggest me.

[janhess]

Have you defined MaxDate in the schema?

[Anonymous]

In the Input SQl component of yours (as per screenshots), the schema should contain the column MaxDate of date datatype.
Going by the screenshot you provided for inputsql, the name for the target table is 'Target' while in your outputsql, the output is going to a table named 'out'. The table you use to fetch teh Max date should be the same table you use in tmssqloutput component.

[Anonymous]

Hi, remytom,
Did you get correct result for your process increment load logic?
Because still iam getting the error. Null pointer exception error in out(tmssqlinput).
In my excel component i have four column. these four column will be created in the tmssqlout with table name is "out",
so how many column i have to create in out(tmssqlinput) , because now iam having only Date column.

Just suggest me what i have to change now in my screen shot.

[Anonymous]

Hi any one can help me to solve this..................
I have created a job in talend data integration open source and now i want to run this job automatically (scheduling) by using spago bi server.
how can i create job scheduling through spago bi server , because the spago bi server is installed in linux(obuntu)machine.
But my talend is installed in my local windows machine.

How can i solve this ........................

[Anonymous]

Hi any one can help me to solve this..................
I have created a job in talend data integration open source and now i want to run this job automatically (scheduling) by using spago bi server.
how can i create job scheduling through spago bi server , because the spago bi server is installed in linux(obuntu)machine.
But my talend is installed in my local windows machine.

How can i solve this ........................

[Anonymous]

How to schedule a talend job in spago bi server when it was in ubuntu server(linux), and my talend job is created in windows.

[Anonymous]

Hi,
Spago BI provides user interface for scheduling a talend job. Follow the instructions for first successfully executing the job using spago...
https://help.talend.com/display/TalendPlatformforMDMStudioUserGuide54EN/7.9.3+How+to+deploy+a+Job+on...
Check your spago documentation for user interface and following specific steps for execution.
Thanks
Vaibhav