This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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:
yes you can use Subfield
Load Filed1, subfield(Field2,',') as Field2
from source table...
View solution in original post
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