Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AbhishekGandhi23
Contributor II
Contributor II

merging data from two different table column into single column

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 

@sunny_talwar @vinieme12 

Labels (1)
1 Reply
Michiel_QV_Fan
Specialist
Specialist

T1:

Load Targetable_status as  Final_status From ....

 

Concatenate (T1)

LOAD SubStatus as  Final_status  From T2;