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

How to combine two fields in load script ?

Hello, 

I have two fields from the same table as shown below; 

Manager
Stillman
George
Adam

 

Developers
Alex
John

 

How to join two fields in the load script as shown below to get new field Employee? 

Employee
Stillman
George
Adam
Alex
John

 

thanks

Labels (2)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

it is possible to resident load and create a table like that
e.g.
load distinct Manager as Employee
resident YourFACT;
concatenate
load distinct Developer as Employee
resident YourFACT;

but bigger question is how it impacts your data model.