APPEND TWO TABLES

shahas71

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

Konstantina

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

shahas71

Hi @konathan
,

Thanks for the quick reply.

This was the answer i was looking for.

Thank u so much

Konstantina

Glad I could help!