I have data below:
Name Id_num
?John. Sal=200;300
Jack. Sal=300;600;500;700
Joseph. Sal=600;700;400?
?
The output should be like below;
Name id_num
John. 200
John. 300
Jack. 300
Jack. 600
Jack. 500
Jack. 700
Joseph. 600
Joseph. 700
Joseph. 400
?
Please help me on this?
Solved! Go to Solution.
@Vardan Negi? @Nathanael Kuipers? can please help me on this. I know how to split but assigning the values is tricky part
Hi @Lakshminarayana Kanala?
Since I see you don't need the "Sal=" portion - I'd suggest you extract a list of numbers to a separate array, than flatten it.,
So, the extraction would look like this -
And the flatten step would look like this -
After words you just need to delete redundant columns and rename the newly-created flattened column.
Does that make sense?
Thanks,
Amit.
It's really helpful for my business case. Thank you so much @Amit Miller? ?
Sure, you're welcome =]