Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
cedfoning
Creator
Creator

Changing data in load script

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 ?

@sunny_talwar @vinieme12 

 

 

Labels (1)
1 Solution

Accepted Solutions
rubenmarin

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...

 

View solution in original post

1 Reply
rubenmarin

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...