topic Re: adding a new value to a field in QlikView

adding a new value to a field

Mon, 13 Feb 2012 16:21:37 GMT

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;

Re: adding a new value to a field

matt_crowther — Mon, 13 Feb 2012 16:27:29 GMT

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

adding a new value to a field

Anonymous — Mon, 13 Feb 2012 16:27:37 GMT

Add this script:

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

adding a new value to a field

Mon, 13 Feb 2012 16:56:38 GMT

worked like a charm. thanks guys