Convert One Column to Multiple Row ( Splitting Column)

[sanyam016]

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

[JordanB]

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

[sanyam016]

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]

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