Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i have an issue :
I have the following table with the following data :
| Matri | ST |
| 18182 | E15 |
| 3948 | E15 |
| 3424 | E15 |
| 2342 | E15 |
| 356 | E15 |
| 66765 | E15 |
| 7876 | E15 |
| 456 | E15 |
| 7867 | E15 |
| 98967 | E15 |
| 976 | E15 |
| 56456 | E15 |
| 98797 | E15 |
| 89789 | E15 |
From the data above, i want to change the values of ST from E15 to E16, but only for certain values of Matri column.
Here are the values :
| 356 |
| 66765 |
| 7876 |
| 456 |
| 7867 |
| 98967 |
| 976 |
Can someone help please ?
Hi, you can do ampping table with the values to change
mapChange:
Mapping LOAD * inline [
Matri, ST
356,E16
66765,E16
...
];
And use the maping table when loading the data:
DataTable:
LOAD Matri,
ApplyMap('mapChange',Matri,ST) as ST
From/Resident...
Hi, you can do ampping table with the values to change
mapChange:
Mapping LOAD * inline [
Matri, ST
356,E16
66765,E16
...
];
And use the maping table when loading the data:
DataTable:
LOAD Matri,
ApplyMap('mapChange',Matri,ST) as ST
From/Resident...