Append two dataset horizontally

deep_215
deep_215 Registered Posts: 9 ✭✭✭

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.

Best Answer

  • Manuel
    Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭
    Answer ✓

    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.

Setup Info
    Tags
      Help me…