Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

Convert One Column to Multiple Row ( Splitting Column)

sanyam016
Level 1
Convert One Column to Multiple Row ( Splitting Column)

Hi Dataiku Enthusiast, I am new to Dataiku. I have a problem statement where i have to convert one column with 1-1 relationship into One-Many relationship as below.

Request if anyone can help on this.

 
 

Capture.PNG


Operating system used: Windows 11

0 Kudos
3 Replies
JordanB
Dataiker

Hi @sanyam016,

It looks like you provided a screenshot of what you want the data to look like, can you please provide an example of what the data looks like currently? tqqqqq

Thanks!

Jordan

0 Kudos
sanyam016
Level 1
Author

Hi Jordan , Thanks for the response.  i have given both. The Values in Column G (Currently) needs to be broken into columns A,B, C & D (Future).

Attachment is also there for the same.

Regards,

Sanyam Goswami

 

 

0 Kudos
JordanB
Dataiker

Hi @sanyam016,

Thanks for clarifying. Unfortunately, your data must already be in raw tabular format. Indeed, you can split a string using a Prepare recipe and a "split column" processor with a delimiter or regex pattern, but it will not treat a data point as an expression. However, you may be able to utilize a Python or R recipe with logic that parses if statements. 

I recommend reading through DSS documentation and getting familiar with the concepts: https://doc.dataiku.com/dss/latest/ 

Thanks again!

Jordan

0 Kudos