Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

parseDate change from 5.0.3 to 5.2.2? by Kwags300
Problem whit context variable in query. by Ginetto
Problem with SELECT a.name AS a_name, b.name AS b_name input by kacper
Component to Connet,Retrieve data from MS OLAP Cube by talend_bso1
SayHelloRoute [...] by gary.liu1119@gmail.com
How to generate jar for use with tBRMS by adaemus
Deployment question regarding [...] by rhuiser

Index
» Installation
» how to mysql table fields and excel fields combined into sing node

Post a reply

Topic review (newest first)

pedro: 2012-05-28 03:33:04

Hi Indira

For any new issue, please start a new topic.

Regards,
Pedro

indira: 2012-05-26 07:28:42

Hi Pedro,

In msql 2 tables have foreign key relationship how to validate this condition for relate to psql

pedro: 2012-05-24 13:16:34

Hi

You might use TalendDate.parseDate() method.

Regards,
Pedro

indira: 2012-05-24 12:13:24

Hi,

Type mismatch: can't convert from string to date how to resolve this issue?

indira: 2012-05-24 12:07:51

Hi Pedro,

I passed the string "100" like this, How to pass fixed date value in the expression field.

pedro: 2012-05-23 04:34:58

Hi Indira

Sorry. I think you'd better download the document [TalendOpenStudio_Components_RG_50b_EN] here and read instructions, scenarios.

I notice that you leave 'schema' on tPostgresqlOutput empty which you should get from postgresql DB.
Besides, in tMap the length of input column 'ISO3' is 3 while the length of related column 'country code' is 2.
Maybe the schema of tPostgresqlOutput is against the structure of this table at DB side.

Regards,
Pedro

indira: 2012-05-22 13:01:50

Hi Pedro,

Thanks for your prompt replies for my issue with mysql & postgre data integration. As simple i am creating the job with one mysql table, postgre sql table & using tmap between two tables. The same error i am getting.
How to send a job file here for you reference.

I have sent a mail from another mail address & uploaded job file also.

please give me your suggestions on the job file.

Thanks
Indira

indira: 2012-05-16 09:10:20

Hi

plz tell me What I do wrong in my job ?

pedro: 2012-05-16 09:07:01

Hi

It should be correct. But I think still there are some wrong settings in your job.

Regards,
Pedro

indira: 2012-05-16 09:04:48

Hi,

Is't correct?

indira: 2012-05-15 10:15:10

Hi Pedro

I have removed the tunite , I have created remaining columns in excel , I have joined excel and tmap but i am getting same issue?

pedro: 2012-05-15 08:24:06

Hi

Now I upload the images I got from your email.

The usage of tUnite is totally wrong here. Please delete it.
Besides, in tMap, you can't leave the expressions of some columns empty.

Regards,
Pedro

indira: 2012-05-15 07:02:51

thanks a lot pedro

pedro: 2012-05-15 06:59:38

Hi

I have received your email.
I will try to find the root reason.

Regards,
Pedro

indira: 2012-05-15 06:56:30

Hi Pedro,

Ok, I sent the mail
got my mail?

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Board footer