How to Split column values into several columns

jrod31
Level 3
How to Split column values into several columns

I have a dataset that has company name and products in the same cell in a column. I need to split the company name and company products into its own column. 

Example:
Column Name is Product - and this entire text is inside 1 cell. 
Company Name¶Company Product¶ExtraTextNotNeeded

I was unable to do it with the Split column recipe. I might be doing it wrong.

Can someone help me or direct me on how to do this? 

 

Thanks, 

0 Kudos
1 Reply
JordanB
Dataiker

Hi @jrod31,

You can try an unnest or unfold object/array step.

Let us know how it goes!

Thanks,

Jordan

0 Kudos