Adding columns from data and assigning values


I wanted to recreate the column headers and assigning values to it basis the values in the next column here is the representation of input and output :

Input :

Output :


Hello @Pranjal_m,

does your data in any time has JSON structure? If so maybe you can use JSON manipulation nodes to deal with your task. Also there are many forum topics around it. Here is one that might help:

Otherwise you can go unpivoting and then extract number after # with regex followed by pivoting. If you would like to see that approach can you share your data? Dummy works just fine :wink:


1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.