Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

adding a new value to a field

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;
Tags (2)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

adding a new value to a field

Add this script:

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

3 Replies
Luminary
Luminary

Re: adding a new value to a field

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

mov
Esteemed Contributor III

adding a new value to a field

Add this script:

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

Not applicable

adding a new value to a field

worked like a charm. thanks guys