Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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;