topic Re: Split date from one column into 3 separate columns in QlikView

Split date from one column into 3 separate columns

Fri, 13 Jul 2012 08:50:47 GMT

Hello,

I am trying to split data from one column into 3 separate columns. My data is being loaded from an Oracle database. Following is my script example:

SQL SELECT "column" FROM LOG.TABLE

The data in the column are of the following format:

abc/123/textdescription

How can I separate this into 3 different columns in QV?

Please help.

Thank you in advance.

Re: Split date from one column into 3 separate columns

jonathandienst — Fri, 13 Jul 2012 08:53:53 GMT

This will do it:

LOAD [column],

SubField([column], '/', 1) As Field1,

SubField([column], '/', 2) As Field2,

SubField([column], '/', 3) As Field3

;

SQL SELECT [column] FROM LOG.TABLE

Hope that helps

Jonathan

Re: Split date from one column into 3 separate columns

Fri, 13 Jul 2012 09:02:29 GMT

Thank you. It works perfectly.

Can you also, tell me how to just reload only the current changes that I made in the script and not the entire script?

Re: Split date from one column into 3 separate columns

jonathandienst — Fri, 13 Jul 2012 10:54:48 GMT

It is possible, but how depends on the details of your script. Essentially you use a partial load with ADD and REPLACE load qualifiers. Search here for partial load, or check out the manual.

Regards

Jonathan