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: 
Tatynout
Contributor III
Contributor III

Script LOAD - Duplicate rows under a condition

Hello, I hope someone can help.

I have a table with the following columns:

RegionSupplierAmount
Europe345610
Africa67965
Europe5687/347615

 

I need to load these data into my QlikSense application with a condition on the Supplier's field.  I want to duplicate a row if there are two  suppliers in the same cell. 

Once loaded into QS i should have the following table:

RegionSupplierAmount
Europe345610
Africa67965
Europe568715
Europe347615

 

Thanks for your help.

Regards,

Tatiana

1 Solution

Accepted Solutions
_armoco_
Partner - Creator II
Partner - Creator II

Hi, 

Try this:

SubField(Supplier,'/') as Supplier

View solution in original post

2 Replies
_armoco_
Partner - Creator II
Partner - Creator II

Hi, 

Try this:

SubField(Supplier,'/') as Supplier

Tatynout
Contributor III
Contributor III
Author

Hello ,

Yes i just tried this and it worked. Thanks 🙂