To break a field value

[upaliwije]

Hi Friends

I have following data in a column

MAKE_MODEL

TOYOTA AURIS
TOYOTA AT-211
TOYOTA AT211
TOYOTA AQUA-DAA-NHP10
TOYOTA AQUA G HYBRID
TOYOTA AQUA
TOYOTA ALTEZZA
TOYOTA ALPHARD

I want to split it into two columns as shown below

MAKE	MODEL
TOYOTA	AURIS
TOYOTA	AT-211
TOYOTA	AT211
TOYOTA	AQUA-DAA-NHP10
TOYOTA	AQUA G HYBRID
TOYOTA	ACQA
TOYOTA	ALTEZZA
TOYOTA	ALPHARD

Kindly help me to do it in my data load script 

[crusader_ · Accepted solution]

Hi,

try below:

left(MAKE_MODEL,index(MAKE_MODEL,' ',1)-1) AS MAKE

mid(MAKE_MODEL,index(MAKE_MODEL,' ',1)+1) AS MODEL

Hope this helps

//Andrei

[marcohadiyanto · Accepted solution]

Hi 

You can use subfield function. example subfield(MAKE_MODEL,' ' ,1) as MAKE,  subfield(MAKE_MODEL,' ' ,2) as MODEL.

More info:

SubField(text, delimiter[, field_no ])

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

Thanks

[upaliwije]

Thanks Both of You