topic Re: How to separate this field into 3 fields in QlikView

How to separate this field into 3 fields

Wed, 25 Nov 2020 16:16:04 GMT

Hi all, appreciate any help here!!

The data in the field looks like this:

"Brick Factory - John Smith - 1234"

Am hoping to split each component into its own field in the load statement using the hyphen characters as separators I guess...

Cheers J

arulsettu — Tue, 16 Aug 2016 07:25:05 GMT

try this

load

SubField('Brick Factory - John Smith - 1234','-',1) as company,

SubField('Brick Factory - John Smith - 1234','-',2) as name

SubField('Brick Factory - John Smith - 1234','-',3) as id

replace with your filed

avinashelite — Tue, 16 Aug 2016 07:39:42 GMT

Try like this

SubField(Field_name,'-',1) as Company,

SubField(Field_name,'-',2) as Name

NOTE: In order to implement this logic your data inflow should be maintained in the same order