topic Re: split a string in QlikView

split a string

Tue, 11 Sep 2012 16:45:20 GMT

Hi,

I want to split a string and need to take first word and save it like a row and also do these for teh second and third and fouth row

ex:

INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO

INCIDENTE |ACCESO | BLOQUEO DE CUENTA| DIRECTORIO ACTIVO

INCIDENTE |APLICACION| NEWHOTEL | ACCESO

thanks

Re: split a string

danielrozental — Tue, 11 Sep 2012 17:18:11 GMT

try subfield

subfield(FIELD,'|') AS SOMETHING

Re: split a string

MayilVahanan — Tue, 11 Sep 2012 17:27:19 GMT

Try something like this

=SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',1) gives INCIDENTE

=SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',2) gives ACCESO

Hope it helps

Re: split a string

Tue, 11 Sep 2012 17:29:18 GMT

THANKS, BUT I NEED THAT EVERY ROW SAVE IN A DIFFERENT FIELD LIKE:

CATEGORIA1

==========

INCIDENTE

REUQEIRMIENTO

CATEGORIA2

==========

ACCESO

APLICACION

CATEGORIA3

===========

BLOQUEO DE CUNETA

NEWHOTEL

I HAVE THIS FIELD LIKE THIS INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO, BUT I NEED IT LIKE I MENTION BEFORE. PLEASE HELP ME

Re: split a string

MayilVahanan — Tue, 11 Sep 2012 17:33:27 GMT

Load *,

SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',1) as CATEGORIA1,

SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',2) as CATEGORIA2

from table;

Hope it helps

Re: split a string

Tue, 11 Sep 2012 17:58:39 GMT

AND HOW CAN I PUT INCIDENTE AND REQUERIMIENTO IN CATEGORIA1???, BECAUSE IT RESULT BUT IT PUT THE CATEGORY EN DIFERENTS ROWS LIKE

CATEGORIA1

INCIDENTE

CATEGORIA2

REQUERIMIENTO

HOW CAN I PUT IT LIEK THIS

CATEGORIA1

INCIDENTE

REQUERIMIENTO

THANKS

Re: split a string

MayilVahanan — Tue, 11 Sep 2012 19:57:52 GMT

where you taken the value as 'REQUERIMIENTO' ? can i know it?

If you want all values as single field?

Re: split a string

Tue, 11 Sep 2012 20:55:28 GMT

Daniel & Mayil pointed you in the right direction. below are your strings and a few test strings...to get Category1 to have INCIDENTE, INCIDENTE2, INCIDENTE3, REUQEIRMENTO....In your app, where are you reading this string from ? If there are just a few lines you can put them in an inline table and use it like below...

Tmp:

Load * Inline [

String

INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO

INCIDENTE2.ACCESO2.Test2 DE CUENTA.DIRECTORIO ACTIVO2

INCIDENTE3.ACCESO3.Test3 DE CUENTA.DIRECTORIO ACTIVO3

REUQEIRMIENTO.APLICACION.NEWHOTEL.DIRECTORIO ACTIVO4

];

Categories:

Load

Subfield(String, '.',1) as Category1,

Subfield(String, '.',2) as Category2,

Subfield(String, '.',3) as Category3,

Subfield(String, '.',4) as Category4

Resident Tmp;

Drop Table Tmp;