Append two dataset horizontally
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
| 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.