Transformation of dataset
![cbimou](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar15.png)
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
-
cbimou Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 12 Partner
Thanks so much @CatalinaS
, this works for me.
Answers
-
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).