Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yanivbm88
Contributor

Reading a column with 'List' data type

Hi,

I am trying to pull data from a table that has one column that hold data from 'list' type. Other columns are from 'string' type.

List is represented a string delimited by a comma.

Is there a simple solution to pull all values in list to the same field, and duplicate the whole line for each value?

I will provide an example:

Input:

UserCodeNameEmail
YANIVB,YANIVBM,YANIV123Yaniv Ben-Malkayaniv@123.com
OMEROmer Shakedomer@123.com


Requested Output:

UserCodeNameEmail
YANIVBYaniv Ben-Malkayaniv@123.com
YANIVBM
Yaniv Ben-Malka
yaniv@123.com
YANIV123
Yaniv Ben-Malka
yaniv@123.com
OMEROmer Shakedomer@123.com
1 Solution

Accepted Solutions
pathiqvd
Contributor III

Re: Reading a column with 'List' data type

Try this,

load *,

SubField(UserCode,',') as UserCode1

from tablename;

3 Replies
pathiqvd
Contributor III

Re: Reading a column with 'List' data type

Try this,

load *,

SubField(UserCode,',') as UserCode1

from tablename;

Re: Reading a column with 'List' data type

Try with subfield function.

Load

SubField(UserCode,',') as UserCode,

Name,

Email

From Source;

yanivbm88
Contributor

Re: Reading a column with 'List' data type

Great, It works!

Didn't realize it is so simple