topic Re: i can t merge two table in Talend Studio

i can t merge two table

hechmi — Mon, 10 Sep 2018 09:32:44 GMT

hi ;

i have two table i would merge in one when i use tunite i cant ,when i see data base i find one table in the out

table 1/: A1, B1 ,C1

table 2: A, B , C

table out :A1, B1 ,C1 hw to find table out us this table out :A1, B1 ,C1

A, B , C

Re: i can t merge two table

manodwhb — Mon, 10 Sep 2018 10:48:39 GMT

@hechmi,are you getting same data types and number of columns and same order to tUnite_3 ? i believe you are not getting the same schemas from the input rows of tUnite_3 . please check.

Re: i can t merge two table

fdenis — Mon, 10 Sep 2018 10:49:27 GMT

it seam to work on your pic,
can you check warning message (yellow sine ! )?

Re: i can t merge two table

hechmi — Mon, 10 Sep 2018 12:19:50 GMT

thks ;
the message warning is :"the tunite merge entry link schema are different, whereas they should be similar"
if i merge two table be wil be ok but three table no

Re: i can t merge two table

manodwhb — Mon, 10 Sep 2018 12:32:40 GMT

@hechmi,third table schema is not matching with other first and second schema to tUnite_3,please make sure you should have same schema for the multiple inputs of tUnite

Re: i can t merge two table

hechmi — Tue, 11 Sep 2018 11:21:27 GMT

hi;

any help please

ih have 3 table have same number colum same name colum

table1 reject date: id___firstnaeme__Price___date__Error mssg

table2 reject Price: id___firstnaeme__Price___date__Error mssg

table3 reject first name :id___firstnaeme__Price___date__Error mssg

when i use tunite to merge the 3 table in out table rejet i find only 2 table

best regards

Re: i can t merge two table

hechmi — Tue, 11 Sep 2018 11:22:13 GMT

hi @fdenis;

any help please

ih have 3 table have same number colum same name colum

table1 reject date: id___firstnaeme__Price___date__Error mssg

table2 reject Price: id___firstnaeme__Price___date__Error mssg

table3 reject first name :id___firstnaeme__Price___date__Error mssg

when i use tunite to merge the 3 table in out table rejet i find only 2 table

best regards

Re: i can t merge two table

hechmi — Tue, 11 Sep 2018 11:24:56 GMT

@manodwhb

hi;

any help please

ih have 3 table have same number colum same name colum

table1 reject date: id___firstnaeme__Price___date__Error mssg

table2 reject Price: id___firstnaeme__Price___date__Error mssg

table3 reject first name :id___firstnaeme__Price___date__Error mssg

when i use tunite to merge the 3 table in out table rejet i find only 2 table

best regards

Re: i can t merge two table

manodwhb — Tue, 11 Sep 2018 11:38:11 GMT

@hechmi,can you show me the three tables schemas?

check the 3rd table schema with other two tables including column order,column names and precision.

Re: i can t merge two table

hechmi — Tue, 11 Sep 2018 11:55:18 GMT

@manodwhb

hi you can seee job merge table

best regard

Capture.PNG
table sql.PNG

Re: i can t merge two table

fdenis — Tue, 11 Sep 2018 12:43:44 GMT

did you check the types of each columns?

Re: i can t merge two table

hechmi — Tue, 11 Sep 2018 12:47:44 GMT

@fdenis

yes i convert all columns to type string

Re: i can t merge two table

fdenis — Tue, 11 Sep 2018 12:51:46 GMT

so disable all input component active only one then run.
then run you job with 2 and 3 and 4 input….
witch on s not running.

Re: i can t merge two table

hechmi — Tue, 11 Sep 2018 14:49:54 GMT

thks @fdenis ;

the merge run ok, but in the out table the colum of 3 table are not visible when searh with with condition where the line is visible but greyed color

best regard

ph.PNG

Re: i can t merge two table

hechmi — Tue, 11 Sep 2018 14:50:41 GMT

thks @manodwhb ;

the merge run ok, but in the out table the colum of 3 table are not visible when searh with with condition where the line is visible but greyed color

best regard

ph.PNG

Re: i can t merge two table

fdenis — Tue, 11 Sep 2018 15:21:00 GMT

disable all others and try.
or try to rebuild this line

Re: i can t merge two table

fdenis — Wed, 12 Sep 2018 11:16:33 GMT

did you solve your problem?

Re: i can t merge two table

hechmi — Wed, 12 Sep 2018 12:02:08 GMT

hi @fdenis;

yes resolved , i convert all colum same type and in table out the number of row limited at 1000 for that i can t see all rows just with filter

thank you ,

best regard

Re: i can t merge two table

hechmi — Wed, 12 Sep 2018 12:21:37 GMT

@fdenis

hi ;

how convert colum type float to string in tmap

thks

Re: i can t merge two table

fdenis — Wed, 12 Sep 2018 12:22:53 GMT

ok fine.
can you tag as Solved to help other person who have the same problem.
Regards