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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Merging two tables

suppose I have excel file like table1 as

name    branch         age          email

aaa       computer        20         a@gmail.com

bbb       civil                 27         b@gmail.com

ccc        IT                   32          c@gmail.com

 

and another excel file table2 as

name      age

ppp           26

qqq           28

 

now i want to join this but here is no any common data

output should be like

 

name    branch         age          email

aaa       computer        20         a@gmail.com

bbb       civil                 27         b@gmail.com

ccc        IT                   32         c@gmail.com

ppp       null                 26         null

qqq       null                 28         null

Labels (2)
11 Replies
Anonymous
Not applicable
Author

@praveenvm you are forgetting about the tMap functionality. Put a tMap after the source data and before the tUnite. Schema alignment is not really that complex in this scenario

TRF
Champion II
Champion II

@Pankaj18, did this help?

If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).