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