Solved: How to split single field into multiple fields - Qlik Community

vinod2086 · ‎2014-11-07

Hi ,

My input

s.no	circuit_speed
1	OTHERS
2	Others MBPS
3	NA
4	Not Applicable
5	620
6	33.512
7	33.512
8	11 Mbps
9	2 kbps
10	40.20 gbps
11	12 gb

but am expecting output see below

s.no	circuit_speed	Unit
1	OTHERS
2	Others	MBPS
3	NA
4	Not Applicable
5	620
6	33.512
7	33.512
8	11	Mbps
9	2	kbps
10	40.2	gbps
11	12	gb

PrashantSangle · ‎2014-11-07

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

Report Inappropriate Content · ‎2014-11-07

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

Anonymous · ‎2014-11-07

Do you have an algorithm for the split ?

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

PrashantSangle · ‎2014-11-07

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂