APPEND TWO TABLES
Options
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 ✭✭✭✭✭OptionsHi @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 ✭✭✭✭✭Options
Glad I could help!