Convert One Column to Multiple Row ( Splitting Column)

Options
sanyam016
sanyam016 Registered Posts: 2 ✭
in Using Dataiku

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

· Share on FacebookShare on Twitter

Answers

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 293 Dataiker
    Options

    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

    · Share on FacebookShare on Twitter
  • sanyam016
    sanyam016 Registered Posts: 2 ✭
    Options

    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

    · Share on FacebookShare on Twitter
  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 293 Dataiker
    Options

    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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…