Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
hechmi
Contributor III
Contributor III

i can t merge two table

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

 

Labels (2)
1 Solution

Accepted Solutions
fdenis
Master
Master

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

View solution in original post

19 Replies
manodwhb
Champion II
Champion II

@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.

fdenis
Master
Master

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

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
manodwhb
Champion II
Champion II

@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

hechmi
Contributor III
Contributor III
Author

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

 

 

hechmi
Contributor III
Contributor III
Author

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

hechmi
Contributor III
Contributor III
Author

@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

manodwhb
Champion II
Champion II

@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. 

hechmi
Contributor III
Contributor III
Author

@manodwhb

hi you can seee job merge table 

best regard


Capture.PNG
table sql.PNG