APPEND TWO TABLES
![shahas71](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar21.png)
shahas71
Dataiku DSS Core Designer, Registered Posts: 12 ✭
Hi All,
i have two tables for eg:
Table 1 :
RULE | BP1 | BP1_PK |
1 | 2 | 3 |
table 2:
RULE | BP2 | BP2_PK |
1 | 5 | 6 |
i need to append these two tables to get the output as:
RULE | BP1 | BP1_PK | BP2 | BP2_PK |
1 | 2 | 3 | ||
1 | 4 | 5 |
Any help would be appreciated.
Thanks in advance
Operating system used: windows
Best Answer
-
Konstantina Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 25 ✭✭✭✭✭
Hi @shahas71
,You could achieve this by using a Stack recipe. On the Selected columns step --> Columns selection, select the Union of input schemas.
P.S. I guess that in your final table the values 4 and 5 should be 5 and 6, respectively, right?
-Konstantina
Answers
-
Hi @konathan
,
Thanks for the quick reply.This was the answer i was looking for.
Thank u so much -
Konstantina Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 25 ✭✭✭✭✭
Glad I could help!