Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mwscott1
Creator
Creator

Prevent subfield from returning last value

I am using subfield in the load to separate out each response using “;” as the delimiter. The problem is the data has a “;” at the end which causes it to return a value. Is there a pay to exclude the last “;” in the load?

LOAD [What would further enhance your experience?],
        SubField([What would further enhance your experience?],';') as [Experience]

Data Example

What would further enhance your experience?

A better understanding of the compensation structure;More information around resources available;

A defined mentor/resource;More information around resources available;A better understanding of the compensation structure;More opportunities for independent learning;

 

 

1 Solution

Accepted Solutions
mato32188
Specialist
Specialist

Hi @mwscott1,

first try to remove last ";", i.e. use LEFT(YourField,LEN(YourField)-1) and secondly merge with subfield.

SUBFIELD( LEFT (YourField, LEN(YourField)-1), ';').

BR

M

ECG line chart is the most important visualization in your life.

View solution in original post

1 Reply
mato32188
Specialist
Specialist

Hi @mwscott1,

first try to remove last ";", i.e. use LEFT(YourField,LEN(YourField)-1) and secondly merge with subfield.

SUBFIELD( LEFT (YourField, LEN(YourField)-1), ';').

BR

M

ECG line chart is the most important visualization in your life.