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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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).