Split and pivot rows

[466582ed7ae8ed0e66cf]

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?

[466582ed7ae8ed0e66cf]

@Vardan Negi? @Nathanael Kuipers? can please help me on this. I know how to split but assigning the values is tricky part

[AMiller_Tri · Accepted solution]

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.

[466582ed7ae8ed0e66cf]

It's really helpful for my business case. Thank you so much @Amit Miller? ?

[AMiller_Tri]

Sure, you're welcome =]