topic Separating Data into Separate Columns in QlikView

Separating Data into Separate Columns

Fri, 08 Jan 2016 12:43:13 GMT

I have data like this:

CODE-PHNNO

08649-235645

0866-2457896

040-2424578

022-7896325

subfield(CODE-PHNNO, '-')AS CODE THE RESULT IS

CODE

08649

235645

0866

2457896 LIKE THIS

BUT I WANT CODE SEPARATE AND PHNNO SEPARATE HOW CAN I?

THANKS

MADHU

Anonymous — Fri, 08 Jan 2016 12:45:51 GMT

try like this?

=subfield(CODE-PHNNO, '-',1) as Code

=subfield(CODE-PHNNO, '-',2) as PHNNO

MK_QSL — Fri, 08 Jan 2016 12:47:47 GMT

Load

SubField(CODE-PHNNO,'-',1) as CODE,

SubField(CODE-PHNNO,'-',-1) as PHNNO

From TableName;