topic Re: Split a column into two in QlikView

Split a column into two

Fri, 27 Mar 2015 08:43:48 GMT

Hi Team,

I have a table containing three fields STUDENT, TYPE and MARKS.

I need to split Column TYPE in to two columns i.e.. SUBJECT and EX_TYPE

SUBJECT column will contain PAPER-I, PAPER-II, PAPER-III and so on.

EX_TYPE column will contain INTERNAL, EXTERNAL, PRACTICAL etc.

Can any one help me out of this problem.

Regards

Priyanka

patroser — Fri, 27 Mar 2015 08:51:50 GMT

should like something like this in load script:

LOAD 
     Student,
     Marks,
     Subfield(Type, ' ', 1) as Subject,
     Subfield(Type, ' ', 2) as Ex_Type
FROM ...

Best regards,

Patrick

Anonymous — Fri, 27 Mar 2015 08:56:11 GMT

You can use a subfield function in your script if the two columns are going to be separated by space.

subfield(Type,' ',1) as SUBJECT,

subfield(Type,' ',2) as EX_TYPE

prieper — Fri, 27 Mar 2015 08:56:58 GMT

Suggest to use SUBFIELD with three params:

SUBFIELD(Type, ' ', 1) AS Subject,

SUBFIELD(Type, ' ', 2) AS ExType

edit: messages crossed - sorry, apostroph removed

HTH Peter

Fri, 27 Mar 2015 09:01:39 GMT

Thanks a lot Patrick