Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

Append two dataset horizontally

Solved!
deep_215
Level 2
Append two dataset horizontally

I Have two dataset with no column in common. My requirement is to append both dataset horizontally. 

For e.g. 

One dataset is 

ABC
111
222

 

Another is 

D
3

 

My desired output should be

ABCD
1113
2223

 

It will be of great help if you can provide me a concrete solution in DataIku for the requirement.

Thanks in advance.

0 Kudos
1 Solution
Manuel
Dataiker
Dataiker

Hi,

Assuming the letters in your example are the column names, it can be achieved with one single step with a Join recipe, selecting the Cross-Join option (see attached image):

  • The cross-join does not require any key columns;
  • The output dataset contains all possible combinations of rows in dataset A and dataset B.

I hope this helps.

View solution in original post

1 Reply
Manuel
Dataiker
Dataiker

Hi,

Assuming the letters in your example are the column names, it can be achieved with one single step with a Join recipe, selecting the Cross-Join option (see attached image):

  • The cross-join does not require any key columns;
  • The output dataset contains all possible combinations of rows in dataset A and dataset B.

I hope this helps.