Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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