merging data from two different table column into single column

AbhishekGandhi23 — Wed, 23 Nov 2022 15:15:51 GMT

I am having two tables - T1 and T2

Targetable_status(column name)

abc

efg

hij

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

Re: merging data from two different table column into single column

Michiel_QV_Fan — Tue, 22 Nov 2022 13:55:53 GMT

T1:

Load Targetable_status as Final_status From ....

Concatenate (T1)

LOAD SubStatus as Final_status From T2;