APPEND TWO TABLES

shahas71
shahas71 Dataiku DSS Core Designer, Registered Posts: 12

Hi All,

i have two tables for eg:

Table 1 :

RULEBP1BP1_PK
123


table 2:

RULEBP2BP2_PK
156


i need to append these two tables to get the output as:

RULEBP1BP1_PKBP2BP2_PK
123
1 45


Any help would be appreciated.

Thanks in advance


Operating system used: windows

Tagged:

Best Answer

  • Konstantina
    Konstantina Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 25 ✭✭✭✭✭
    Answer ✓

    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

Setup Info
    Tags
      Help me…