topic Renaming values in QlikView

Renaming values

volakakis — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys!!!!

Little help here needed

I have a Table and one column (B) has values in the format of XXX.##### (for example BSN.70249 )

Is there a way to change the Letter? Lets say BSN.70249 into NIK.70249????

Thank you in advence

sunny_talwar — Tue, 04 Apr 2017 11:24:36 GMT

May be this

Replace(B, 'BSN', 'NIK')

sunny_talwar — Tue, 04 Apr 2017 11:25:19 GMT

Or this for multiple changes

volakakis — Tue, 04 Apr 2017 11:43:47 GMT

No it doesnt work.

BSN.70249 into NIK.70249

BSN.78931 into NIK.78931

and so on

I cant use the proposed ways

sunny_talwar — Tue, 04 Apr 2017 11:46:33 GMT

Replace function isn't working? Really?

volakakis — Tue, 04 Apr 2017 11:47:57 GMT

not in my load script sorry

sunny_talwar — Tue, 04 Apr 2017 11:48:41 GMT

Seemed to have worked for me

Table:

LOAD *,

Replace(OriginalValue, 'BSN', 'NIK') as NewValue;

LOAD * Inline [

OriginalValue

BSN.70249

BSN.78931

];

sunny_talwar — Tue, 04 Apr 2017 11:48:57 GMT

Check the attached sample

volakakis — Tue, 04 Apr 2017 11:54:09 GMT

ok .... my misstake. forgot to rename the new one..... sorry!!!!

Thank you very much