Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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
@Pankaj18, did this help?
If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).