Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How do I preload data in new field in Data Load Editor

I'm new to Qlik Sense so forgive my ignorance. I'm creating a new table from an existing load using the resident predicate.  I want the new table to have a new field called "Region" and have all rows underneath prefilled with "NAFTA".  

How do I do this in the load script?

Load
[Vehicle_x0020_Line-eu28] as fam,
[Program_x0020_Status-eu28] as status
Resident [properties-eu28];

DROP TABLE [properties-eu28];

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Give a try on the below code:

 

Load
[Vehicle_x0020_Line-eu28] as fam,
[Program_x0020_Status-eu28] as status,

'NAFTA' as Region
Resident [properties-eu28];

DROP TABLE [properties-eu28];

View solution in original post

2 Replies
Highlighted
Master II
Master II

Give a try on the below code:

 

Load
[Vehicle_x0020_Line-eu28] as fam,
[Program_x0020_Status-eu28] as status,

'NAFTA' as Region
Resident [properties-eu28];

DROP TABLE [properties-eu28];

View solution in original post

Highlighted
Contributor II
Contributor II

Thanks! It worked perfectly