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: 
Sxbbb
Creator III
Creator III

I want to weld WorkOrder_BaseOutput with Type by creating a new table

I have Table  

Output:
LOAD     WorkOrder_BaseOutput

and  I have Table   

FATCC:
LOAD  Type,
 WorkOrder_Base

I want to weld WorkOrder_BaseOutput with Type by creating a new table 

I've tried doing this. But the data  is incorrect

TEST:

LOAD  WorkOrder_Base  as  WorkOrder_BaseOutput,

              Type as Type_Output

Resident FATCC;

 

 

 

 

 

 

Labels (4)
1 Reply
Aasir
Creator III
Creator III

To concatenate

Output:
LOAD
WorkOrder_BaseOutput
Resident WorkOrder_BaseOutput;

FATCC:
LOAD
Type,
WorkOrder_Base
Resident FATCC;

Concatenate (TEST)
LOAD
WorkOrder_Base as WorkOrder_BaseOutput,
Type as Type_Output
Resident FATCC;