Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Many thanks!
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
];
Massimo, thank you!