topic Re: String insert in QlikView

String insert

Thu, 09 Jul 2015 20:06:40 GMT

Hi,

a) I want to sufix '_c' to a field:

1) script side

2) Expression

b) I want to reomve the sufix '_c' to a filed

1)script

2) expression

ex:

Filed: ID

898

566

100000

987776

Thanks

Re: String insert

petter — Thu, 09 Jul 2015 20:10:53 GMT

Simply:

RENAME FIELD ID TO ID_c_;

RENAME FIELD ID_c TO ID;

RENAME FIELD ID_c_ TO ID_c;

Re: String insert

Thu, 09 Jul 2015 20:15:06 GMT

i want the output to be

68_c

98776_c

not 'name field_c'

Re: String insert

sunny_talwar — Thu, 09 Jul 2015 20:16:35 GMT

Then try this:

LOAD

ID & '_c' as ID

Re: String insert

Qrishna — Thu, 09 Jul 2015 20:17:10 GMT

Suffix '_c' to a field name: possible only in script

As petter mentioned:

RENAME FIELD ID TO ID_c_;

RENAME FIELD ID_c TO ID;

RENAME FIELD ID_c_ TO ID_c;

or simply use 'AS' key word eg ID as ID_c_ :

if you want to suffix '_c' to the data of the field ID:

ID & '_c' AS ID_new.

To remove:

PurgeChar (ID_new, '_c') AS ID_purged

Re: String insert

Thu, 09 Jul 2015 20:37:28 GMT

not working ...

I guess

integer to string.. issue

Re: String insert

MarcoWedel — Thu, 09 Jul 2015 22:07:02 GMT

to purge the trailing _c you could use:

If(ID like '*_c',Left(ID,Len(ID)-2),ID)

hope this helps

regards

Marco