MAPPING, ApplyMap: examplo
// Nota: salto adrede algunos números
MiMapa:
Mapping
LOAD *
INLINE [
Code, Value
1, Mercury
2, Mars
3, Venus
7, Saturn
8, Jupiter
];
TablaSinMapping:
LOAD * INLINE [
UnIndice
1
2
3
4
5
6
7
8
9
10
];
QUALIFY *;
MiTablaConCampoMapeado:
LOAD
UnIndice as indice_original,
applymap(‘MiMapa’,UnIndice) as indice_mapeado
resident TablaSinMapping;
ConValorPorDefecto:
NoConcatenate
LOAD
UnIndice as indice_original,
applymap(‘MiMapa’,UnIndice,’NS/NC’) as indice_mapeado
resident TablaSinMapping;
UNQUALIFY *;