Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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;

 

 

 

 

 

 

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;