Duplicate records based on filed values

[379SSS]

Hi all,

I have a requirement as like

Table1:
load * Inline [
Product_ID,ProductName
1,Mango&Banana&Apple
2,Apple&Banana&Mango
3,Apple&Mango&Banana
4,Banana&Mango&Apple
];

Require output:

Product_ID, ProductName

1,Mango
1,Banana
1,Apple
2,Banana
2,Mango
2,Apple
3,Apple
3,Banana
3,Mango
4,Mango
4,Apple
4,Banana

please let me know if anyone can help here.

Thank you in advance!

[MayilVahanan · Accepted solution]

Hi

Try with subfield function like

Table1:
load Product_ID , subfield(ProductName, '&') as ProductName Inline [
Product_ID,ProductName
1,Mango&Banana&Apple
2,Apple&Banana&Mango
3,Apple&Mango&Banana
4,Banana&Mango&Apple
];

[379SSS]

Thanks for the reply @MayilVahanan 

Is there any alternate solution for this?