topic Re: How to split single field into multiple fields in QlikView

How to split single field into multiple fields

vinod2086 — Fri, 07 Nov 2014 11:18:42 GMT

Hi ,

My input

but am expecting output see below

Fri, 07 Nov 2014 11:21:09 GMT

Keepchar('Others MBPS','MBPS') as unit

Anonymous — Fri, 07 Nov 2014 11:21:53 GMT

Do you have an algorithm for the split ?

Cannot split on the space a 'Not Applicable" has a space

PrashantSangle — Fri, 07 Nov 2014 11:25:39 GMT

Hi,

Try this in script,

if(wildmatch(circuit_speed,'*mb*','*kb*','*gb*'),subfield(circuit_speed,' ',2)) as Unit,

if(wildmatch(circuit_speed,'*mb*','*kb*','*gb*'),subfield(circuit_speed,' ',1),circuit_speed) as Ne_Circuit_Speed

Regards