topic Re: loading values from field in QlikView

loading values from field

arsenal1983 — Fri, 18 Mar 2016 08:54:25 GMT

Hello,

In my source data I have field which contains values separated by comma is there any chance to do the list from such value?

Example:

I Have:

I need to have:

ali_hijazi — Fri, 18 Mar 2016 08:55:37 GMT

yes you can use Subfield

Load Filed1, subfield(Field2,',') as Field2

from source table...

avinashelite — Fri, 18 Mar 2016 08:58:01 GMT

yes its possible , use the subfield function

subfield(field_name,',') as new_field

sunny_talwar — Fri, 18 Mar 2016 08:58:58 GMT

Sample for your requirement:

Table:

LOAD Group,

SubField(Country, ', ') as Country;

LOAD * Inline [

Group|Country

GROUP_1|AFRICA, EUROPE

GROUP_2|ASIA

GROUP_3|EUROPE, ASIA

] (delimiter is |);

Kushal_Chawda — Fri, 18 Mar 2016 08:59:07 GMT

try this

LOAD Group,

subfield(Country,',') as Country

From Table

Ralf-Narfeldt — Fri, 18 Mar 2016 08:59:19 GMT

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