topic Re: Separate feild to 3 feilds in QlikView

Separate feild to 3 feilds

Anonymous — Wed, 22 Aug 2012 11:07:33 GMT

hay

i have feild that containing kod , for exm. 12f , 13i, 14s, 12i , 12s...

the sign is color and the number is Texture.

i want to make new feild that containing the all kod with "s" how can i do it ?

thank's for your help.

yarin.

Re: Separate feild to 3 feilds

sreenivas — Wed, 22 Aug 2012 11:18:24 GMT

Table:

Load if((Right(KOD,1)='s'),KOD)as Kod1;

LOAD * INLINE [

KOD

12f

13i

14s

12i

12s

];

Re: Separate feild to 3 feilds

jagan — Wed, 22 Aug 2012 11:48:26 GMT

Hi,

Try this script

Test:

Load If(Index(KOD, 's'), KOD) AD TempKod;

LOAD * INLINE [

KOD

12f

13i

14s

12i

12s

];

Hope this helps you.

Regards,

Jagan.