Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Parse Field during LOAD

Hi,

my source data contains a table with just two fields:

SalesProducts
JohnFood, Goods, Electronic
JackFood, Drinks, Games, Cars

From this format i would like to create a table like:

SalesProduct
JohnFood
JohnGoods
JohnElectronic
JackFood
JackDrinks
JackGames
Jack Cars

Some help of how i can loop through the field and extract value by value would be much appreciated!

thanks,

P

1 Solution

Accepted Solutions
Colin-Albert

Use the subfield() function

Load

     Sales

     subfield(Products, ',') as Product

from ....

View solution in original post

2 Replies
Colin-Albert

Use the subfield() function

Load

     Sales

     subfield(Products, ',') as Product

from ....

ashfaq_haseeb
Champion III
Champion III

Hi,

Try like this

LOAD Sales,

     Products,

    trim(subfield(Products, ',')) as NewProduct

FROM

[http://community.qlik.com/thread/142160]

(html, codepage is 1256, embedded labels, table is @1);

Regards

ASHFAQ