Transformation of dataset

Solved!
cbimou
Level 2
Transformation of dataset

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 ๐Ÿ™‚

0 Kudos
1 Solution
cbimou
Level 2
Author

Thanks so much @CatalinaS , this works for me.

View solution in original post

0 Kudos
2 Replies
CatalinaS
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

cbimou
Level 2
Author

Thanks so much @CatalinaS , this works for me.

0 Kudos