Script LOAD - Duplicate rows under a condition

[Tatynout]

Hello, I hope someone can help.

I have a table with the following columns:

Region	Supplier	Amount
Europe	3456	10
Africa	6796	5
Europe	5687/3476	15

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:

Region	Supplier	Amount
Europe	3456	10
Africa	6796	5
Europe	5687	15
Europe	3476	15

Thanks for your help.

Regards,

Tatiana

[_armoco_ · Accepted solution]

Hi, 

Try this:

SubField(Supplier,'/') as Supplier

[Tatynout]

Hello ,

Yes i just tried this and it worked. Thanks 🙂