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

[konathan · Accepted solution]

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 🙂

[konathan]

Glad I could help! 😊