Transformation of dataset

cbimou

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

cbimou

Thanks so much @CatalinaS
, this works for me.

Catalina

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).