Discussion Board for collaboration on QlikView Scripting.
In my source data I have field which contains values separated by comma is there any chance to do the list from such value?
I need to have:
Go to Solution.
yes you can use Subfield
Load Filed1, subfield(Field2,',') as Field2
from source table...
yes its possible , use the subfield function
subfield(field_name,',') as new_field
Sample for your requirement:
SubField(Country, ', ') as Country;
LOAD * Inline [
] (delimiter is |);
subfield(Country,',') as Country
Yes, with the SubField() function. It will split a field based on a delimiter.
If the field is called REGIONS use:
SubField(REGIONS,',') As REGION
This will create 2 records for the value AFRICA, EUROPE with AFRICA and EUROPE in new field REGION
SubField ‒ QlikView