how can i convert this data

[PankajChaudhary]

I have used groupBy node which given this table

now, i need to convert this table in to this table

the unpivoting node has not worked in my case
can you please help me in it?

[aworker]

Hi @PankajChaudhary

When you do a unique concatenation using “Unique Concatenante” as you did, the result is a string with unique concatenated values. A string cannot be easily ungrouped.

However, if you want to ungroup, then you rather need use the aggregation option “Set”, which creates a list with unique values. A set can be ungrouped using the Ungroup node to eventually obtain the result you wish.

Hope this helps. Otherwise, just let me know.

Best regards,

Ael

[PankajChaudhary]

Thanks for the suggestion it worked.