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

unable to convert Numeric field to [...] by AlphaWhiskey1
Date Parsing and Locales by Opus
Filters in WebUI to limit records for individual users by Adrian.at.Talend
Issues with .csv files created by the tFileOutputDelimited component. by tgrady
Integer fields from Cache database always returning zeros by jbdailey
Job does not run concurrently in [...] by xalkideos
Insert into geometry column single quotes problem by nko

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

Post a reply

Write your message and submit

Name

E-mail

Message

Options

Never show smilies as icons for this post

Click in the dark area of the image to send your post.

Go back

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