Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Qlik Sense question.
I would like to know if there is a way to change the data's content of a column in my table.
For instance, I have created a table with three columns as shown below
LL5678 3056 AB
LJ4432 3000 AB
LL3567 3400 AB
LF2390 3001 AB
LJ1200 3000 AB
LF3450 4000 AB
and so on.
If I need to change the letter L to P, while leaving other alphabets and numbers unchanged, in the first column in order to get
PP5678 3056 AB
PJ4432 3000 AB
PP3567 3400 AB
PF2390 3001 AB
PJ1200 3000 AB
PF3450 4000 AB
and so on.
Is it possible to create such table with the original data or with the data load editor?
I will appreciate all your help.
Use replace function:
Replace(text,from_str,to_str)