Discussion board where members can get started with QlikView.
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:
How can I separate this into 3 different columns in QV?
Thank you in advance.
Go to Solution.
This will do it:
SubField([column], '/', 1) As Field1,
SubField([column], '/', 2) As Field2,
SubField([column], '/', 3) As Field3
SQL SELECT [column] FROM LOG.TABLE
Hope that helps
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?
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.