Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having two tables - T1 and T2
T1
Targetable_status(column name)
abc
efg
hij
T2
SubStatus(column name)
xyz
mno
I want to merge two column ("Targetable_status" & "SubStatus") data into single column.
Expected result -
Final_status
abc
efg
hij
xyz
mno
Please help me in above issue
T1:
Load Targetable_status as Final_status From ....
Concatenate (T1)
LOAD SubStatus as Final_status From T2;