Assigning unique ID and creating loop using that ID

bhargavikn — Tue, 26 Oct 2021 07:43:45 GMT

Hello,

I'm trying to load first 3 values for each Product ID and assigning that 3 values to 3 different new columns as below.

Could you please help me to create a unique ID for Product ID and load first 3 values of each product ID.

We have table as below:

Output should be like below:

I hope requirement is clear. please help me with solution.

Thanks.

Re: Assigning unique ID and creating loop using that ID

MarcoWedel — Tue, 26 Oct 2021 19:28:18 GMT

what do you mean by "new columns"?

Actual columns in a front end object or fields in a data model table?

bhargavikn — Wed, 27 Oct 2021 04:44:49 GMT

Thanks for reply.. need fields in data model