Extracting values from a comma seperated string

[#1]

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 · Accepted solution]

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

];

[#3]

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 🙂