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

[resajdak]

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];

[trdandamudi · Accepted solution]

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];

[resajdak]

Thanks! It worked perfectly