topic Re: Extracting values from a comma seperated string in QlikView

Extracting values from a comma seperated string

Thu, 05 Mar 2015 07:19:39 GMT

Hey Guys,

I want to extract each company that is assigned to the Name in order to do a section access.

The two fields in the Screenshot below are two database fields.

I want the Result for the user "Barsch" to be like this:

Barsch, 100

Barsch, 110

Barsch, 120

Barsch, 210

Büch, 100

...

All suggestions welcome 🙂

MK_QSL — Thu, 05 Mar 2015 07:22:28 GMT

Load

Name,

SubField(Company,',') as Company

From TableName;

Use below sample example..

Load

Name,

SubField(Value,':') as Value Inline

[

Name, Value

A, 100:200:300:400

B, 1000:2000:3000:4000

];

Thu, 05 Mar 2015 07:26:11 GMT

Perfect. I tried the SubField before, but I didn't get the desired result. My mistake was the 1 at the end.

Thanks for the quick reply 🙂