2 Different table same column name but values are change how to grp it

[Shoban_01]

Hi Guys,

this is my question like

table 1	table 2
raja	raja1
rani	rani
ramu	ramu23

current state. I need output is 

like

table 1 + table 2

raja1

rani

ramu23

[Gabbar]

Try this

Load *,
If(Len(Table)>Len(Table2),Table1,Table2) as Table1+Table2 
resident (Your Table Name);