Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Append two dataset horizontally
Added on February 7, 2022 11:24AM
Likes: 0
Replies: 1
deep_215
Registered Posts: 12 ✭✭✭✭
I Have two dataset with no column in common. My requirement is to append both dataset horizontally.
For e.g.
One dataset is
| A | B | C |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
Another is
| D |
| 3 |
My desired output should be
| A | B | C | D |
| 1 | 1 | 1 | 3 |
| 2 | 2 | 2 | 3 |
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 Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭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.