Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Recoding in script

Hi everyone!

I'm a beginner in working with QlickView.

Which function allows to recode values? For example, I have Field with six values (1,2,3,4,5,6) and I want to recode them this way (1 2 3 = copy) (4 5 = 4) (6=5).

is it possible to do that within LOAD function?

4 Replies
datanibbler
Champion
Champion

Hi Marina,

sure. There are several ways. You can do it in the LOAD with an IF-function or you can use a mapping table. The latter is more practical if the method of recoding can change over time (if going forward, you might want to map 4 against 'copy', too)

HTH

Not applicable
Author

Many thanks!

maxgro
MVP
MVP

or

load

field,

pick(match(field, 1,2,3,4,5,6), 1,2,3,4,4,5)

inline [

field

1

2

3

4

5

6

];

Not applicable
Author

Massimo, thank you!