Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivbm88
Creator
Creator

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
Creator III
Creator III

Try this,

load *,

SubField(UserCode,',') as UserCode1

from tablename;

View solution in original post

3 Replies
pathiqvd
Creator III
Creator III

Try this,

load *,

SubField(UserCode,',') as UserCode1

from tablename;

its_anandrjs

Try with subfield function.

Load

SubField(UserCode,',') as UserCode,

Name,

Email

From Source;

yanivbm88
Creator
Creator
Author

Great, It works!

Didn't realize it is so simple