Parse Field during LOAD

[#1]

Hi,

my source data contains a table with just two fields:

Sales	Products
John	Food, Goods, Electronic
Jack	Food, Drinks, Games, Cars

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

Sales	Product
John	Food
John	Goods
John	Electronic
Jack	Food
Jack	Drinks
Jack	Games
Jack	Cars

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

thanks,

P

[Colin-Albert · Accepted solution]

Use the subfield() function

Load

     Sales

     subfield(Products, ',') as Product

from ....

[ashfaq_haseeb]

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