topic Re: Duplicate records based on filed values in App Development

Duplicate records based on filed values

379SSS — Fri, 15 Nov 2024 21:53:29 GMT

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!

Re: Duplicate records based on filed values

MayilVahanan — Tue, 18 Apr 2023 09:24:24 GMT

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
];

Re: Duplicate records based on filed values

379SSS — Tue, 18 Apr 2023 09:40:19 GMT

Thanks for the reply @MayilVahanan

Is there any alternate solution for this?