Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
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
Hi
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
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?
Hi
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