Convert One Column to Multiple Row ( Splitting Column)
![sanyam016](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar3.png)
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.
Operating system used: Windows 11
Answers
-
JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 295 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
-
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
-
JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 295 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