Transformation of dataset

cbimou
cbimou Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 12 Partner

Hi All

Here is my requirement.

I want to transform my dataset from image 1 to image 2 by using visual recipe ideally or pyspark code if not possible.

Can some one help me please.

Thanks in advance

Best Answer

Answers

  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker

    Hi @cbimou
    ,

    Based on the images you need to do cartesian product between 2 columns. This can be achieved by doing a cross join between the input dataset and itself and keeping first column from the first dataset and the second column from the second dataset (see below screenshots).

    Screenshot 2022-08-24 at 18.50.03.pngScreenshot 2022-08-24 at 18.50.15.png

Setup Info
    Tags
      Help me…