Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
bhaveshp90
Contributor 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
Partner
Partner

Re: How to combine two fields in load script ?

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.