Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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;