adding a new value to a field

[#1]

hello

I'm trying to add two additional values to a field when loading "service as Cost_activity."  the field only has 3 values (A, B, C) for cost_activity.  I want to add in the script "D" and "E" as values which do not currently exisit in the source table.  how do a I add them?

LOAD

id as service_id,
service as cost_activity,


SQL SELECT *
FROM service;

[matt_crowther]

Try this:

Data:

LOAD
id as service_id,
service as cost_activity,
SQL SELECT *
FROM service;

Concatenate (Data)
Load * Inline [
cost_activity
D
E

];

That should crack it.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

[Anonymous · Accepted solution]

Add this script:

CONCATENATE
LOAD * INLINE [
service_id,  cost_activity
'service id for D', D
'service id for E', E
];

[#4]

worked like a charm. thanks guys